57 rows where Neighborhoods (old) = 23 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

These facets timed out: Neighborhoods (old)

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)
8590 142524 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145) 3 1 10 308 23
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
55266 142521 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
66275 142545 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
69868 142549 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 11 Sidewalk: Curb side : Cutout Tree SFUSD 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.410795492578 (37.8049613971858, -122.410795492578) 3 1 10 308 23
71668 142546 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206) 3 1 10 308 23
83356 142550 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 16 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 6 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 12 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 Width 0ft   6009689.0581 2121206.8206 37.8049757647303 -122.410719306308 (37.8049757647303, -122.410719306308) 3 1 10 308 23
125465 142523 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 13 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009712.3662 2121206.8206 37.8049770715314 -122.410638645677 (37.8049770715314, -122.410638645677) 3 1 10 308 23
134500 142542 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453) 3 1 10 308 23
153778 142519 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 Width 0ft   6009452.9889 2121171.5596 37.8048657081731 -122.411533760714 (37.8048657081731, -122.411533760714) 3 1 10 308 23
165062 142548 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822) 3 1 10 308 23
191008 142543 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924) 3 1 10 308 23
3324 100985 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Potential Site :: Potential Site 48 450X Chestnut St 4 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Acer saccharinum :: Silver Maple 271 350 Broadway 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.402853834756 (37.7984395708796, -122.402853834756) 3 1 10 308 23
49150 100970 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 2 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 7 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 9 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 10 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 6 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   0   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
106695 100983 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
121961 100979 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 11 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
182607 100976 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 8 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 1 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
3937 98576 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 301X Francisco St 14 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 11 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
47784 98579 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 17 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
73345 98561 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
79751 98566 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 4 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301X Francisco St 15 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 2 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 5 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 16 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 8 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 12 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 6 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 1 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 10 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 13 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 3 Sidewalk: Curb side : Cutout Tree SFUSD 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 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23

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