trees

132 rows where qSpecies_id = 264

✎ View and edit SQL

This data as json, CSV (advanced)

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)
150815 40545 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 345 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42654 5992118.57883529 2094673.32580486 37.731121073004 -122.469590627875 (37.731121073004, -122.469590627875) 9 8 4 59 40
151749 43605 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 2200 32nd Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43259 5986395.85454499 2100254.47526952 37.7461130198438 -122.489785115263 (37.7461130198438, -122.489785115263) 1 8 3 29491 35
153962 39679 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 516 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41065 5993023.20922319 2090620.12525576 37.7200442196585 -122.466168751019 (37.7200442196585, -122.466168751019) 9 8 6 64 24
156395 52482 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 621 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48592 6009833.91672451 2098677.23566801 37.7431228988796 -122.408627690112 (37.7431228988796, -122.408627690112) 10 7 7 28859 2
157450 41996 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 80 Manor Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42334 5993638.39101115 2093445.81341471 37.7278383466678 -122.464247330355 (37.7278383466678, -122.464247330355) 9 8 4 59 40
157740 108513 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 1627 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773657 5991127.72815 2104318.94699 37.7575481445436 -122.473719517598 (37.7575481445436, -122.473719517598) 1 8 4 56 12
160293 42392 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 300 Gennessee St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
161277 37493 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 731 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39962 5992316.91775959 2105881.3475753 37.7619068878184 -122.469720600579 (37.7619068878184, -122.469720600579) 1 8 4 56 12
161900 42292 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 116 Detroit St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42522 5999442.6223058 2093534.55961029 37.7284148636898 -122.44418842044 (37.7284148636898, -122.44418842044) 9 7 4 63 40
162108 45366 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 731 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2001 12:00:00 AM     Permit Number 44190 5993491.07633098 2090711.88313734 37.7203231472606 -122.46455816594 (37.7203231472606, -122.46455816594) 9 8 6 64 24
163497 42386 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 243 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42552 5997421.03900624 2094234.76852517 37.7302219319368 -122.451227574103 (37.7302219319368, -122.451227574103) 9 7 4 28861 40
165493 45529 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 1350 Eucalyptus Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM     Permit Number 44289 5987443.24617798 2094721.87705329 37.7309830600177 -122.48575742371 (37.7309830600177, -122.48575742371) 1 8 4 64 35
166517 39640 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 559 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41034 5992713.24259274 2090915.62277372 37.7208376954569 -122.467261665472 (37.7208376954569, -122.467261665472) 9 8 6 64 24
168704 45530 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 1350 Eucalyptus Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM     Permit Number 44289 5987443.24617798 2094721.87705329 37.7309830600177 -122.48575742371 (37.7309830600177, -122.48575742371) 1 8 4 64 35
169386 39678 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 512 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41064 5993022.88525791 2090592.33519606 37.7199678962015 -122.466167852387 (37.7199678962015, -122.466167852387) 9 8 6 64 24
170062 57166 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 196 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1974 12:00:00 AM 4   Permit Number 14443 6005251.30084842 2100223.69671579 37.747111404786 -122.424583147021 (37.747111404786, -122.424583147021) 2 7 5 28859 22
170703 40455 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 383 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1999 12:00:00 AM     Permit Number 41540 6006383.45382408 2096953.23791682 37.7381953336537 -122.420436145768 (37.7381953336537, -122.420436145768) 2 7 7 28859 2
171774 45354 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 319 Victoria St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2001 12:00:00 AM     Permit Number 44180 5993213.8738989 2089318.70115228 37.7164818216733 -122.465415204128 (37.7164818216733, -122.465415204128) 9 8 6 64 24
172009 41998 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 84 Manor Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42335 5993653.01173216 2093471.86469921 37.7279107198294 -122.464198677078 (37.7279107198294, -122.464198677078) 9 8 4 59 40
172894 98358 Undocumented 4 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 224@Napier Filbert St 1 Sidewalk: Property side : Yard Tree Private 2     6     6011805 2120142 37.8021704358049 -122.403321855362 (37.8021704358049, -122.403321855362) 3 1 10 308 23
174522 48562 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 426 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/2002 12:00:00 AM     Permit Number 45877 5992755.40001086 2090026.9420249 37.7184000274946 -122.467051364561 (37.7184000274946, -122.467051364561) 9 8 6 64 24
174773 41989 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 11 Keystone Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42330 5994048.97742437 2092696.42288542 37.7258043598685 -122.462773593164 (37.7258043598685, -122.462773593164) 9 8 4 59 40
176390 42402 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 50 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42556 6000898.48623088 2094375.50054285 37.7308068438612 -122.439215689304 (37.7308068438612, -122.439215689304) 9 7 4 63 40
178995 41984 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 965 Darien Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42324 5994668.75537429 2093899.33702485 37.7291429475058 -122.460718216521 (37.7291429475058, -122.460718216521) 9 8 4 59 40
180175 41997 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 84 Manor Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42335 5993653.01173216 2093471.86469921 37.7279107198294 -122.464198677078 (37.7279107198294, -122.464198677078) 9 8 4 59 40
180776 35407 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 350 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38862 6003669.60279278 2098674.23740749 37.7427674952278 -122.429942019936 (37.7427674952278, -122.429942019936) 2 7 5 63 22
181432 39635 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 545 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41030 5992712.45358581 2090818.32890073 37.7205705046206 -122.46725732212 (37.7205705046206, -122.46725732212) 9 8 6 64 24
184349 40268 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 21 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 774463 6006679.69418317 2103656.77350185 37.7566184133932 -122.419887443178 (37.7566184133932, -122.419887443178) 2 4 7 28859 19
185195 42393 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 598x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
187220 49128 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 44 Southwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/2003 12:00:00 AM     Permit Number 46258 5995619.79574134 2092494.23612321 37.7253395505633 -122.457328802945 (37.7253395505633, -122.457328802945) 9 7 4 28861 40
193745 38085 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 2501 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
194146 34249 Permitted Site 7 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 174 Majestic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/01/2003 12:00:00 AM     Permit Number 46663 5996827.5342502 2089032.06513255 37.7159025350879 -122.452903999886 (37.7159025350879, -122.452903999886) 9 8 6 28861 24

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