trees

Custom SQL query returning 66 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
63609 222900 1 5 3733 20th St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   6005413.47026 2104278.82733 37.7582550109751 -122.424310747749 (37.7582550109751, -122.424310747749) 2 4 5 28859 19
113265 59009 7 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree 2   04/07/1980 12:00:00 AM 15 4x4 Permit Number 18300 6005405.85335043 2104274.1193379 37.758241653827 -122.424336755524 (37.758241653827, -122.424336755524) 2 4 5 28859 19
30477 222899 1 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 6ft   6005393.47694 2104277.70893 37.7582508111316 -122.424379813902 (37.7582508111316, -122.424379813902) 2 4 5 28859 19
32130 5658 1 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
62825 246517 1 5 41 Waller St 1 : Tree 2     3 Width 3ft   6005417.73549 2109222.56247 37.7718295731126 -122.424647671566 (37.7718295731126, -122.424647671566) 7 9 5 28852 10
17663 101489 4 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
36033 37053 7 5 231 Duncan St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/08/2015 12:00:00 AM 3 6x9 Permit Number 775674 6005030.06979159 2099868.96006137 37.7461248828886 -122.425322907066 (37.7461248828886, -122.425322907066) 2 7 5 63 22
62291 5529 1 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
149886 5523 1 5 865 Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     50 3X3   6005084.41522 2103351.40166 37.7556899313628 -122.425382766602 (37.7556899313628, -122.425382766602) 2 4 5 28859 19
172971 96123 7 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767774 6004920.8 2095965.5 37.7354006937902 -122.425423007406 (37.7354006937902, -122.425423007406) 2 7 5 28861 2
61480 246510 1 5 231 Duncan St 1 : Tree 2     1 Width 5ft   6004993.26159 2099869.66747 37.7461247456624 -122.425450235552 (37.7461247456624, -122.425450235552) 2 7 5 63 22
135947 225081 4 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6004907.37106 2095955.144 37.7353714997996 -122.425468699532 (37.7353714997996, -122.425468699532) 2 7 5 28861 2
131158 5479 1 5 695 Dolores St 1 Sidewalk: Curb side : Cutout Tree 1     20 8   6005031.79334 2104320.15384 37.758346924379 -122.425633695438 (37.758346924379, -122.425633695438) 2 4 5 28859 19
27880 438 1 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
30088 5432 1 5 499 Dolores St 1 Sidewalk: Curb side : Cutout Tree 2     36 3X3   6004968.15127 2105494.35348 37.7615674029223 -122.425937381218 (37.7615674029223, -122.425937381218) 8 4 5 28859 19
182657 5384 1 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
77058 222893 1 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
54428 50386 7 5 296 Liberty St 5 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
99119 50383 7 5 296 Liberty St 2 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
103441 50384 7 5 296 Liberty St 7 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
130611 50385 7 5 296 Liberty St 6 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
131762 50388 7 5 296 Liberty St 3 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
48763 225089 1 5 838 Church St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6004316.16009 2104019.9015 37.7574820391842 -122.428087274435 (37.7574820391842, -122.428087274435) 2 4 5 28862 3
193471 225085 1 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.428508555547 (37.7505398125629, -122.428508555547) 2 4 5 28862 22
50898 49041 7 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46216 6004132.32350443 2101573.22879489 37.7507536483556 -122.428548658976 (37.7507536483556, -122.428548658976) 2 4 5 28862 22
60894 246420 1 5 400 Duncan St 2 Sidewalk: Curb side : Yard Tree 2     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.429398275524 (37.7460188154337, -122.429398275524) 2 7 5 63 22
110454 246421 1 5 400 Duncan St 3 Sidewalk: Curb side : Yard Tree 2     7 Width 4ft   6003840.65408 2099855.19689 37.7460198226686 -122.429434772709 (37.7460198226686, -122.429434772709) 2 7 5 63 22
4441 246422 1 5 400 Duncan St 4 Sidewalk: Curb side : Yard Tree 2     9 Width 4ft   6003829.35465 2099854.81871 37.7460181445246 -122.429473817668 (37.7460181445246, -122.429473817668) 2 7 5 63 22
74298 225086 1 5 3689 21st St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6003831.7176 2103603.4271 37.7563110786983 -122.429732966312 (37.7563110786983, -122.429732966312) 2 4 5 28862 22
77339 225088 1 5 3899 19th St 3 Sidewalk: Property side : Yard Tree 2     11 Width 3ft   6003725.04695 2104766.83601 37.7594994820291 -122.430184865761 (37.7594994820291, -122.430184865761) 2 4 5 28862 3
85099 225087 1 5 3901 19th St 3 Sidewalk: Property side : Yard Tree 2     11 Width 3ft   6003680.66693 2104762.35118 37.7594846540097 -122.430338033793 (37.7594846540097, -122.430338033793) 2 4 5 28862 3
185943 225083 1 5 3782 22nd St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6003229.02977 2103031.88331 37.7547076090931 -122.431776461616 (37.7547076090931, -122.431776461616) 2 4 5 28862 22
21283 225084 1 5 3784 22nd St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6003185.26448 2103031.00379 37.7547027131682 -122.431927750974 (37.7547027131682, -122.431927750974) 2 4 5 28862 22
31579 225050 1 5 500x 27th St 24 Median : Cutout Tree 1     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866) 2 7 5 63 22
175659 225049 1 5 500x 27th St 22 Median : Cutout Tree 1     6 Width 4ft   6002919.63953 2100068.30287 37.7465527734974 -122.432634735922 (37.7465527734974, -122.432634735922) 2 7 5 63 22
134226 16641 7 5 161 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002897.9493228 2107328.6416625 37.7664866995789 -122.433228426337 (37.7664866995789, -122.433228426337) 15 5 5 28862 3
172953 34010 7 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   04/28/1997 12:00:00 AM     Permit Number 37945 6002886.66979468 2107551.69377695 37.7670985064042 -122.433283380019 (37.7670985064042, -122.433283380019) 15 5 5 28862 3
172314 225082 1 5 543 Hill St 1 Sidewalk: Curb side : Cutout Tree 2     22 Width 3ft   6002779.31526 2103257.03916 37.7553003306644 -122.433347783174 (37.7553003306644, -122.433347783174) 2 4 5 28862 22
74388 16650 7 5 190 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002855.60879 2107200.17785 37.7661315672606 -122.433365693732 (37.7661315672606, -122.433365693732) 15 5 5 28862 3
54510 225090 1 5 188 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002851.63466 2107200.77986 37.7661329947706 -122.433379482476 (37.7661329947706, -122.433379482476) 15 5 5 28862 3
177221 61796 7 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21819 6002883.06164476 2108748.24537279 37.7703837393735 -122.433381373664 (37.7703837393735, -122.433381373664) 15 5 5 29492 9
47329 16647 1 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   09/04/2015 12:00:00 AM 14 4x4   6002850.60519 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722) 15 5 5 28862 3
66656 16644 1 5 170 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 4X4   6002849.24717 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987) 15 5 5 28862 3
18931 16634 1 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
2297 16623 1 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
62764 16626 1 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree 1   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721) 15 5 5 28862 3
146708 116858 1 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
22540 225094 1 5 621 Waller St 1 Sidewalk: Curb side : Cutout Tree 2   11/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780775 6002723.2165 2108842.98565 37.7706348030957 -122.433941050651 (37.7706348030957, -122.433941050651) 15 5 5 29492 9
108284 225093 1 5 635 Waller St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6002682.06353 2108837.51126 37.770617436283 -122.434083007749 (37.770617436283, -122.434083007749) 15 5 5 29492 9
124058 225092 1 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002638.75231 2108633.09345 37.7700536971488 -122.434218205527 (37.7700536971488, -122.434218205527) 15 5 5 29492 9
113085 58721 7 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree 2   03/16/1981 12:00:00 AM     Permit Number 19065 6002629.53182761 2108749.25499909 37.7703721248343 -122.434258404788 (37.7703721248343, -122.434258404788) 15 5 5 29492 9
117653 205999 1 5 60 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6001682.52176 2095686.82759 37.7344520302196 -122.436598984369 (37.7344520302196, -122.436598984369) 2 7 5 63 7
168615 4389 1 5 56 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree 1   06/09/2008 12:00:00 AM 30 3x3   6001657.8215553 2095631.9001159 37.7342998083721 -122.436680450501 (37.7342998083721, -122.436680450501) 2 7 5 63 7
131544 59362 7 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2   11/21/1980 12:00:00 AM     Permit Number 18713 6001270.92113106 2096540.31776103 37.7367721171555 -122.4380831379 (37.7367721171555, -122.4380831379) 2 7 5 63 7
51291 225053 1 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6001218.80684 2096592.16387 37.7369115105593 -122.438267032523 (37.7369115105593, -122.438267032523) 2 7 5 63 7
191495 225054 1 5 342 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 2ft   6001139.36381 2096693.29596 37.7371846769336 -122.438548945674 (37.7371846769336, -122.438548945674) 2 7 5 63 7
127978 225055 1 5 348 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 2ft   6001114.83392 2096694.1461 37.7371856158122 -122.438633817409 (37.7371856158122, -122.438633817409) 2 7 5 63 7
62355 225056 1 5 354 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6001081.74278 2096696.02818 37.737188901045 -122.438748363154 (37.737188901045, -122.438748363154) 2 7 5 63 7
172941 225057 1 5 360 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6001062.01743 2096696.77883 37.7371898399477 -122.438816616317 (37.7371898399477, -122.438816616317) 2 7 5 63 7
67810 41699 7 5 2 Mizpah St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42149 6001021.55719924 2096664.38095079 37.7370985809646 -122.438954184383 (37.7370985809646, -122.438954184383) 2 7 5 63 7
170988 225052 1 5 375 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6000953.83658 2096674.21341 37.7371217252913 -122.439189029173 (37.7371217252913, -122.439189029173) 2 7 5 63 7
152653 51304 7 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767250 6001037.11613846 2102279.06351254 37.7525160532628 -122.439302719451 (37.7525160532628, -122.439302719451) 2 4 5 28862 22
110285 32421 1 5 400 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2   10/08/1996 12:00:00 AM 12   Permit Number 36948 6000917.26502 2096711.23126 37.7372212865363 -122.439318125938 (37.7372212865363, -122.439318125938) 2 7 5 63 7
34635 225051 1 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6000881.81518 2102275.99981 37.7524988021808 -122.439839555559 (37.7524988021808, -122.439839555559) 2 4 5 28862 22
134432 32473 1 5 144 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/10/1996 12:00:00 AM 9   Permit Number 36981 6000263.91054 2106227.11632 37.7633124078752 -122.442259981907 (37.7633124078752, -122.442259981907) 15 5 5 28862 3
48301 225091 1 5 169 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6000007.70524 2106202.33536 37.7632297601708 -122.443144329371 (37.7632297601708, -122.443144329371) 15 5 5 28862 3