trees

133 rows where qSpecies_id = 66 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
193173 186364 DPW Maintained 1 Shrub :: Shrub 66 1801 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402) 1 8 3 56 35
193262 252868 DPW Maintained 1 Shrub :: Shrub 66 15 Foerster St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.448906166111 (37.7286944544712, -122.448906166111) 9 7 4 28861 40
186666 65625 Permitted Site 7 Shrub :: Shrub 66 238 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.7300996701998 -122.425384739364 (37.7300996701998, -122.425384739364) 9 7 6 28861 5
78365 12755 DPW Maintained 1 Shrub :: Shrub 66 1733 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.7859184370017 -122.478259694764 (37.7859184370017, -122.478259694764) 11 6 2 55 26
87985 237035 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 2 : Tree DPW 1   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918) 7 9 11 28852 10
32529 237036 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 4 : Tree DPW 1   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.05318 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022) 7 9 11 28852 10
147554 239154 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 6 : Tree DPW 1   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387849 (37.773736235682, -122.42371387849) 7 9 11 28852 10
82677 244391 DPW Maintained 1 Shrub :: Shrub 66 250 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.423913347785 (37.774530388668, -122.423913347785) 7 9 11 28852 10
118266 244393 DPW Maintained 1 Shrub :: Shrub 66 250 Octavia St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501) 7 9 11 28852 10
143999 244348 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681) 7 9 11 28852 10
126230 244349 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.7750839362118 -122.424033097665 (37.7750839362118, -122.424033097665) 7 9 11 28852 10
90692 244351 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.424046881247 (37.7751744977295, -122.424046881247) 7 9 11 28852 10
126561 244299 DPW Maintained 1 Shrub :: Shrub 66 350 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533) 7 9 11 28852 10
21592 244300 DPW Maintained 1 Shrub :: Shrub 66 350 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.7754530855803 -122.424102299872 (37.7754530855803, -122.424102299872) 7 9 11 28852 10
73743 244301 DPW Maintained 1 Shrub :: Shrub 66 350 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.7754944371133 -122.424111541162 (37.7754944371133, -122.424111541162) 7 9 11 28852 10
163415 139390 DPW Maintained 1 Shrub :: Shrub 66 432 OCTAVIA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.7765300709458 -122.424352241322 (37.7765300709458, -122.424352241322) 7 9 11 28852 10
105604 23896 DPW Maintained 1 Shrub :: Shrub 66 1581 Webster St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/24/2017 12:00:00 AM 3 3x3   6003535.3531022 2114132.0136397 37.7852032161945 -122.431509502733 (37.7852032161945, -122.431509502733) 13 9 11 29490 13
68664 94197 Permitted Site 7 Shrub :: Shrub 66 355 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
96160 94198 Permitted Site 7 Shrub :: Shrub 66 355 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
44868 37377 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 11 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
51790 37371 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 5 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
175412 37379 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 13 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
161681 4313 DPW Maintained 1 Shrub :: Shrub 66 727 Chenery St 1 Sidewalk: Curb side : Cutout Landscaping DPW 1   08/17/2013 12:00:00 AM   3X3   6002321.25178 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497) 2 7 5 63 7
9604 56991 Permitted Site 7 Shrub :: Shrub 66 4160 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.7482201548247 -122.432903090117 (37.7482201548247, -122.432903090117) 2 4 5 28862 22
67643 92611 DPW Maintained 1 Shrub :: Shrub 66 3856 23rd St   Sidewalk: Property side : Pot Landscaping Private 2   08/31/2009 12:00:00 AM     Permit Number 52924 6004067 2102488 37.7532616988935 -122.428839761175 (37.7532616988935, -122.428839761175) 2 4 5 28862 22
14115 61098 Permitted Site 7 Shrub :: Shrub 66 806 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.415549543793 (37.7554885536992, -122.415549543793) 2 4 7 28859 19
25702 89015 DPW Maintained 1 Shrub :: Shrub 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping Private 2   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
101202 88829 DPW Maintained 1 Shrub :: Shrub 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping Private 2   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
16936 24292 DPW Maintained 1 Shrub :: Shrub 66 403 Winfield St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/1992 12:00:00 AM 3 3X3                      
66991 96631 Permitted Site 7 Shrub :: Shrub 66 1212 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359) 11 8 11 56 12
80964 15877 DPW Maintained 1 Shrub :: Shrub 66 5508 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389) 9 7 6 28861 25
35821 93164 DPW Maintained 1 Shrub :: Shrub 66 201 Upper Ter 2 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
133338 93163 DPW Maintained 1 Shrub :: Shrub 66 201 Upper Ter 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 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)
);