66 rows where Supervisor Districts = 5 and qSpecies_id = 5 sorted by Longitude

View and edit SQL

Supervisor Districts

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
63609 222900 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3733 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005413.47026 2104278.82733 37.7582550109751 -122.424310747749 (37.7582550109751, -122.424310747749) 2 4 5 28859 19
113265 59009 Permitted Site 7 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 6ft   6005393.47694 2104277.70893 37.7582508111316 -122.424379813902 (37.7582508111316, -122.424379813902) 2 4 5 28859 19
32130 5658 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
62825 246517 DPW Maintained 1 Ceratonia siliqua :: Carob 5 41 Waller St 1 : Tree Private 2     3 Width 3ft   6005417.73549 2109222.56247 37.7718295731126 -122.424647671566 (37.7718295731126, -122.424647671566) 7 9 5 28852 10
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 231 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
149886 5523 DPW Maintained 1 Ceratonia siliqua :: Carob 5 865 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6005084.41522 2103351.40166 37.7556899313628 -122.425382766602 (37.7556899313628, -122.425382766602) 2 4 5 28859 19
172971 96123 Permitted Site 7 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 231 Duncan St 1 : Tree Private 2     1 Width 5ft   6004993.26159 2099869.66747 37.7461247456624 -122.425450235552 (37.7461247456624, -122.425450235552) 2 7 5 63 22
135947 225081 Undocumented 4 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004907.37106 2095955.144 37.7353714997996 -122.425468699532 (37.7353714997996, -122.425468699532) 2 7 5 28861 2
131158 5479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 695 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 8   6005031.79334 2104320.15384 37.758346924379 -122.425633695438 (37.758346924379, -122.425633695438) 2 4 5 28859 19
27880 438 DPW Maintained 1 Ceratonia siliqua :: Carob 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
30088 5432 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3   6004968.15127 2105494.35348 37.7615674029223 -122.425937381218 (37.7615674029223, -122.425937381218) 8 4 5 28859 19
182657 5384 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
77058 222893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
54428 50386 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 5 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 7 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 6 Sidewalk: Curb side : Cutout Tree Private 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 838 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004316.16009 2104019.9015 37.7574820391842 -122.428087274435 (37.7574820391842, -122.428087274435) 2 4 5 28862 3
193471 225085 DPW Maintained 1 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.428508555547 (37.7505398125629, -122.428508555547) 2 4 5 28862 22
50898 49041 Permitted Site 7 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.429398275524 (37.7460188154337, -122.429398275524) 2 7 5 63 22
110454 246421 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6003840.65408 2099855.19689 37.7460198226686 -122.429434772709 (37.7460198226686, -122.429434772709) 2 7 5 63 22
4441 246422 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6003829.35465 2099854.81871 37.7460181445246 -122.429473817668 (37.7460181445246, -122.429473817668) 2 7 5 63 22
74298 225086 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3689 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003831.7176 2103603.4271 37.7563110786983 -122.429732966312 (37.7563110786983, -122.429732966312) 2 4 5 28862 22
77339 225088 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3899 19th St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6003725.04695 2104766.83601 37.7594994820291 -122.430184865761 (37.7594994820291, -122.430184865761) 2 4 5 28862 3
85099 225087 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3901 19th St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6003680.66693 2104762.35118 37.7594846540097 -122.430338033793 (37.7594846540097, -122.430338033793) 2 4 5 28862 3
185943 225083 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3782 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003229.02977 2103031.88331 37.7547076090931 -122.431776461616 (37.7547076090931, -122.431776461616) 2 4 5 28862 22
21283 225084 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3784 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003185.26448 2103031.00379 37.7547027131682 -122.431927750974 (37.7547027131682, -122.431927750974) 2 4 5 28862 22
31579 225050 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 24 Median : Cutout Tree DPW 1     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866) 2 7 5 63 22
175659 225049 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 22 Median : Cutout Tree DPW 1     6 Width 4ft   6002919.63953 2100068.30287 37.7465527734974 -122.432634735922 (37.7465527734974, -122.432634735922) 2 7 5 63 22
134226 16641 Permitted Site 7 Ceratonia siliqua :: Carob 5 161 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6002897.9493228 2107328.6416625 37.7664866995789 -122.433228426337 (37.7664866995789, -122.433228426337) 15 5 5 28862 3
172953 34010 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 543 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6002779.31526 2103257.03916 37.7553003306644 -122.433347783174 (37.7553003306644, -122.433347783174) 2 4 5 28862 22
74388 16650 Permitted Site 7 Ceratonia siliqua :: Carob 5 190 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6002855.60879 2107200.17785 37.7661315672606 -122.433365693732 (37.7661315672606, -122.433365693732) 15 5 5 28862 3
54510 225090 DPW Maintained 1 Ceratonia siliqua :: Carob 5 188 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002851.63466 2107200.77986 37.7661329947706 -122.433379482476 (37.7661329947706, -122.433379482476) 15 5 5 28862 3
177221 61796 Permitted Site 7 Ceratonia siliqua :: Carob 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 170 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002849.24717 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987) 15 5 5 28862 3
18931 16634 DPW Maintained 1 Ceratonia siliqua :: Carob 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
2297 16623 DPW Maintained 1 Ceratonia siliqua :: Carob 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
62764 16626 DPW Maintained 1 Ceratonia siliqua :: Carob 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
22540 225094 DPW Maintained 1 Ceratonia siliqua :: Carob 5 621 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 635 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002682.06353 2108837.51126 37.770617436283 -122.434083007749 (37.770617436283, -122.434083007749) 15 5 5 29492 9
124058 225092 DPW Maintained 1 Ceratonia siliqua :: Carob 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002638.75231 2108633.09345 37.7700536971488 -122.434218205527 (37.7700536971488, -122.434218205527) 15 5 5 29492 9
113085 58721 Permitted Site 7 Ceratonia siliqua :: Carob 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 60 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001682.52176 2095686.82759 37.7344520302196 -122.436598984369 (37.7344520302196, -122.436598984369) 2 7 5 63 7
168615 4389 DPW Maintained 1 Ceratonia siliqua :: Carob 5 56 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 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 Permitted Site 7 Ceratonia siliqua :: Carob 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001218.80684 2096592.16387 37.7369115105593 -122.438267032523 (37.7369115105593, -122.438267032523) 2 7 5 63 7
191495 225054 DPW Maintained 1 Ceratonia siliqua :: Carob 5 342 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001139.36381 2096693.29596 37.7371846769336 -122.438548945674 (37.7371846769336, -122.438548945674) 2 7 5 63 7
127978 225055 DPW Maintained 1 Ceratonia siliqua :: Carob 5 348 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6001114.83392 2096694.1461 37.7371856158122 -122.438633817409 (37.7371856158122, -122.438633817409) 2 7 5 63 7
62355 225056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 354 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001081.74278 2096696.02818 37.737188901045 -122.438748363154 (37.737188901045, -122.438748363154) 2 7 5 63 7
172941 225057 DPW Maintained 1 Ceratonia siliqua :: Carob 5 360 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6001062.01743 2096696.77883 37.7371898399477 -122.438816616317 (37.7371898399477, -122.438816616317) 2 7 5 63 7
67810 41699 Permitted Site 7 Ceratonia siliqua :: Carob 5 2 Mizpah St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000953.83658 2096674.21341 37.7371217252913 -122.439189029173 (37.7371217252913, -122.439189029173) 2 7 5 63 7
152653 51304 Permitted Site 7 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000881.81518 2102275.99981 37.7524988021808 -122.439839555559 (37.7524988021808, -122.439839555559) 2 4 5 28862 22
134432 32473 DPW Maintained 1 Ceratonia siliqua :: Carob 5 144 Lower Ter 1 Sidewalk: Curb side : Cutout Tree Private 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 DPW Maintained 1 Ceratonia siliqua :: Carob 5 169 Lower Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000007.70524 2106202.33536 37.7632297601708 -122.443144329371 (37.7632297601708, -122.443144329371) 15 5 5 28862 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);