68 rows where qCaretaker_id = 2 and qSpecies_id = 48 sorted by Latitude

View and edit SQL

These facets timed out: qCaretaker_id

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)
4037 260562 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 10 Sidewalk: Curb side : Cutout Landscaping Private 2       6x15   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
8171 260560 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 8 Sidewalk: Curb side : Cutout Landscaping Private 2       6x8   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
13072 260558 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 6 Sidewalk: Curb side : Cutout Landscaping Private 2       6x6   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
14896 260559 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 7 Sidewalk: Curb side : Cutout Landscaping Private 2       6x12   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
18080 260563 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 11 Sidewalk: Curb side : Cutout Landscaping Private 2       6x10   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
19343 260561 DPW Maintained 1 Potential Site :: Potential Site 48 260 Sagamore St 9 Sidewalk: Curb side : Cutout Landscaping Private 2       6x7   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
4221 160246 Private 9 Potential Site :: Potential Site 48 962 Edinburgh St 1 Front Yard : Cutout Tree Private 2 DPW 02/20/2020 12:00:00 AM 3 3x3 Permit Number 779047 6001480.24176 2088600.7563 37.7149837880375 -122.436791243222 (37.7149837880375, -122.436791243222) 9 7 6 28861 5
16865 163540 DPW Maintained 1 Potential Site :: Potential Site 48 619 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5995031.00917 2089139.41682 37.716094181887 -122.459121355691 (37.716094181887, -122.459121355691) 9 8 6 28861 24
10048 258883 Undocumented 4 Potential Site :: Potential Site 48 1198X Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996138 2091849 37.7235976355668 -122.455490816534 (37.7235976355668, -122.455490816534) 9 8 4 28861 24
19196 258834 Undocumented 4 Potential Site :: Potential Site 48 1198X Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996138 2091849 37.7235976355668 -122.455490816534 (37.7235976355668, -122.455490816534) 9 8 4 28861 24
6533 258833 Undocumented 4 Potential Site :: Potential Site 48 1199X Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996025 2091881 37.7236790151497 -122.455883747529 (37.7236790151497, -122.455883747529) 9 8 4 28861 24
14522 258882 Undocumented 4 Potential Site :: Potential Site 48 1199X Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996025 2091881 37.7236790151497 -122.455883747529 (37.7236790151497, -122.455883747529) 9 8 4 28861 24
136876 256136 Undocumented 4 Potential Site :: Potential Site 48 799X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008891 2096498 37.7370863389093 -122.411734106556 (37.7370863389093, -122.411734106556) 10 7 7 28859 2
156155 256137 Undocumented 4 Potential Site :: Potential Site 48 799X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008891 2096501 37.7370945762582 -122.411734318471 (37.7370945762582, -122.411734318471) 10 7 7 28859 2
120146 256138 Undocumented 4 Potential Site :: Potential Site 48 701x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008779 2096509 37.7371102589049 -122.412122119739 (37.7371102589049, -122.412122119739) 10 7 7 28859 2
39308 187624 DPW Maintained 1 Potential Site :: Potential Site 48 325 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991928 2097693 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928) 1 8 4 59 40
96239 187623 DPW Maintained 1 Potential Site :: Potential Site 48 325 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991928 2097693 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928) 1 8 4 59 40
133720 187653 DPW Maintained 1 Potential Site :: Potential Site 48 307 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992004 2097696 37.7394139526506 -122.470206771239 (37.7394139526506, -122.470206771239) 1 8 4 59 40
3850 262121 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
7182 262122 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
10464 155454 DPW Maintained 1 Potential Site :: Potential Site 48 19 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 787674 5993257.21896 2098988.14634 37.7430342344373 -122.465967594028 (37.7430342344373, -122.465967594028) 1 8 4 59 40
6207 166623 DPW Maintained 1 Potential Site :: Potential Site 48 520 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2017 12:00:00 AM 3 Width 3ft Permit Number 18521 6001647.24706 2101482.78936 37.7503643764264 -122.437135780708 (37.7503643764264, -122.437135780708) 2 4 5 28862 22
194364 265034 Undocumented 4 Potential Site :: Potential Site 48 3012 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009402 2101646 37.7512502705876 -122.410330719668 (37.7512502705876, -122.410330719668) 2 4 7 28859 19
5250 264790 Undocumented 4 Potential Site :: Potential Site 48 2640 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
5644 264791 Undocumented 4 Potential Site :: Potential Site 48 2640 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
194337 265035 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194339 265037 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194353 265038 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194365 265036 Undocumented 4 Potential Site :: Potential Site 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
119450 173669 DPW Maintained 1 Potential Site :: Potential Site 48 1200X Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009203.67582999 2102144.49744393 37.7526079137784 -122.411051756336 (37.7526079137784, -122.411051756336) 2 4 7 28859 19
13550 183989 DPW Maintained 1 Potential Site :: Potential Site 48 1678 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5985337.681 2103783.3365 37.7557404662473 -122.493704080582 (37.7557404662473, -122.493704080582) 1 8 3 56 35
18177 224546 DPW Maintained 1 Potential Site :: Potential Site 48 3287 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006409.4351 2103750.6223 37.7568608711517 -122.420828760756 (37.7568608711517, -122.420828760756) 2 4 7 28859 19
2739 39562 DPW Maintained 1 Potential Site :: Potential Site 48 1012 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2016 12:00:00 AM 9 3x3 Permit Number 40983 6012154.28622 2103652.62912 37.7569139356407 -122.40095392338 (37.7569139356407, -122.40095392338) 10 3 8 28856 29
2911 258680 Undocumented 4 Potential Site :: Potential Site 48 2824 21st St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009247 2103976 37.7576392372832 -122.411031286576 (37.7576392372832, -122.411031286576) 2 4 7 28859 19
48999 152672 DPW Maintained 1 Potential Site :: Potential Site 48 785 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008560.11555 2103990.56133 37.7576406768849 -122.413407851099 (37.7576406768849, -122.413407851099) 2 4 7 28859 19
10491 261696 DPW Maintained 1 Potential Site :: Potential Site 48 1590 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5989373 2104538 37.758047821522 -122.479804035874 (37.758047821522, -122.479804035874) 1 8 3 56 35
11893 182452 DPW Maintained 1 Potential Site :: Potential Site 48 1574 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5989346.5396 2104640.2207 37.7583269548751 -122.47990302642 (37.7583269548751, -122.47990302642) 1 8 3 56 35
12646 261695 DPW Maintained 1 Potential Site :: Potential Site 48 1470 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5989346 2105344 37.7602593121964 -122.479956394756 (37.7602593121964, -122.479956394756) 1 8 3 56 35
13956 228261 DPW Maintained 1 Potential Site :: Potential Site 48 444 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002291.44131 2105618.97889 37.761757957597 -122.435203927241 (37.761757957597, -122.435203927241) 15 4 5 28862 3
39960 258413 Permitted Site 7 Potential Site :: Potential Site 48 119 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004727 2108913 37.7709405550078 -122.427014922048 (37.7709405550078, -122.427014922048) 7 9 11 28852 10
97540 254135 DPW Maintained 1 Potential Site :: Potential Site 48 779 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991599 2110135 37.7735447550356 -122.472513696557 (37.7735447550356, -122.472513696557) 11 6 2 54 26
842 261260 DPW Maintained 1 Potential Site :: Potential Site 48 431 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   6004908 2110310 37.7747866111117 -122.426488326031 (37.7747866111117, -122.426488326031) 7 9 11 28852 10
18588 261261 DPW Maintained 1 Potential Site :: Potential Site 48 425 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   6004928 2110351 37.7749003177122 -122.426422061759 (37.7749003177122, -122.426422061759) 7 9 11 28852 10
64729 139829 DPW Maintained 1 Potential Site :: Potential Site 48 925 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6005130.3176 2112304.2753 37.7802749685253 -122.425861267784 (37.7802749685253, -122.425861267784) 7 9 11 28852 41
4151 251414 DPW Maintained 1 Potential Site :: Potential Site 48 10x Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
15403 251413 DPW Maintained 1 Potential Site :: Potential Site 48 10x Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
16223 251415 DPW Maintained 1 Potential Site :: Potential Site 48 10x Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
157754 251416 DPW Maintained 1 Potential Site :: Potential Site 48 10x Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
125158 169170 DPW Maintained 1 Potential Site :: Potential Site 48 750 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 3x3   6006877.96422 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057) 7 9 9 28858 36
5012 261384 Undocumented 4 Potential Site :: Potential Site 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
16085 261385 Undocumented 4 Potential Site :: Potential Site 48 238 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008591 2113342 37.7833192745132 -122.413962560517 (37.7833192745132, -122.413962560517) 7 10 9 28852 36
157133 169168 DPW Maintained 1 Potential Site :: Potential Site 48 701 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.419291136796 (37.7833385660552, -122.419291136796) 7 9 9 28858 36
11948 264853 DPW Maintained 1 Potential Site :: Potential Site 48 840 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
19185 264854 DPW Maintained 1 Potential Site :: Potential Site 48 840 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
23952 169219 DPW Maintained 1 Potential Site :: Potential Site 48 840 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
30535 255733 DPW Maintained 1 Potential Site :: Potential Site 48 840 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
160069 169218 DPW Maintained 1 Potential Site :: Potential Site 48 824 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 3x3   6006905.30546 2113639.62991 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287) 7 9 9 28858 36
160755 169217 DPW Maintained 1 Potential Site :: Potential Site 48 800 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.419722395865 (37.7840627073778, -122.419722395865) 7 9 9 28858 36
186594 169214 DPW Maintained 1 Potential Site :: Potential Site 48 724 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0 Width 4ft   6007369.54432 2113705.88387 37.7842497348906 -122.418214130293 (37.7842497348906, -122.418214130293) 7 9 9 28858 36
120415 120659 DPW Maintained 1 Potential Site :: Potential Site 48 160 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 778623 6015041.8167 2115476.8576 37.7895412902416 -122.391794432707 (37.7895412902416, -122.391794432707) 6 2 9 28855 6
24094 120658 DPW Maintained 1 Potential Site :: Potential Site 48 160 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 778623 6015062.3817 2115495.3661 37.7895932519157 -122.391724574055 (37.7895932519157, -122.391724574055) 6 2 9 28855 6
165356 120657 DPW Maintained 1 Potential Site :: Potential Site 48 160 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 778623 6015078.8336 2115510.7898 37.7896365150846 -122.39166873056 (37.7896365150846, -122.39166873056) 6 2 9 28855 6
20245 200985 Undocumented 4 Potential Site :: Potential Site 48 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft Permit Number 778623 6015097.3421 2115526.2135 37.7896798923825 -122.391605771311 (37.7896798923825, -122.391605771311) 6 2 9 28855 6
46345 200984 Undocumented 4 Potential Site :: Potential Site 48 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft Permit Number 778623 6015113.794 2115545.7503 37.7897344491206 -122.391550215359 (37.7897344491206, -122.391550215359) 6 2 9 28855 6
5615 200997 Undocumented 4 Potential Site :: Potential Site 48 150 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft Permit Number 778623 6015155.9522 2115579.6824 37.7898299587744 -122.391406724 (37.7898299587744, -122.391406724) 6 2 9 28855 6
124371 200996 Undocumented 4 Potential Site :: Potential Site 48 150 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 778623 6015175.4889 2115602.3039 37.789893156498 -122.3913407103 (37.789893156498, -122.3913407103) 6 2 9 28855 6
10006 200995 Undocumented 4 Potential Site :: Potential Site 48 150 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft Permit Number 778623 6015191.9409 2115616.6994 37.7899335962877 -122.391284794105 (37.7899335962877, -122.391284794105) 6 2 9 28855 6
100810 258347 Undocumented 4 Potential Site :: Potential Site 48 373 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010476 2118794 37.7983948432015 -122.407825748362 (37.7983948432015, -122.407825748362) 3 1 10 308 4

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)
);