trees
45 rows where qSpecies_id = 261
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3577 | 224274 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1300 San Jose Ave | 50 | Front Yard : Yard | Tree | Private 2 | 24 | 6003341.28829 | 2095541.99849 | 37.7341484865614 | -122.430853752702 | (37.7341484865614, -122.430853752702) | 2 | 7 | 5 | 63 | 7 | ||||
| 11144 | 191785 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014578.31828 | 2109612.65593 | 37.7734137828497 | -122.392987636094 | (37.7734137828497, -122.392987636094) | 14 | 3 | 9 | 310 | 20 | |||
| 21053 | 102182 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1824 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x7 | 6003456.0858 | 2115079.584 | 37.7878005119829 | -122.43185142562 | (37.7878005119829, -122.43185142562) | 13 | 9 | 11 | 29490 | 27 | |||
| 30037 | 224270 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1000 San Jose Ave | 99 | Front Yard : Yard | Tree | Private 2 | 31 | 6004965.43171 | 2096836.50087 | 37.7377947878061 | -122.425330660777 | (37.7377947878061, -122.425330660777) | 2 | 7 | 5 | 63 | 7 | ||||
| 36568 | 191793 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014414.77166 | 2109457.62888 | 37.7729790271794 | -122.393542519577 | (37.7729790271794, -122.393542519577) | 14 | 3 | 9 | 310 | 20 | |||
| 38794 | 191748 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014426.86102 | 2107413.78571 | 37.767367758551 | -122.393357645966 | (37.767367758551, -122.393357645966) | 14 | 3 | 9 | 310 | 20 | |||
| 39942 | 191790 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014469.3027 | 2109510.05157 | 37.7731259980049 | -122.393357557806 | (37.7731259980049, -122.393357557806) | 14 | 3 | 9 | 310 | 20 | |||
| 56536 | 191791 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014449.77124 | 2109490.54971 | 37.7730713650891 | -122.393423755125 | (37.7730713650891, -122.393423755125) | 14 | 3 | 9 | 310 | 20 | |||
| 56976 | 191741 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 301 Mendell St | 7 | : | Tree | Private 2 | 17 | Width 4ft | 6016911.13187 | 2097912.78393 | 37.7414177012714 | -122.38410311127 | (37.7414177012714, -122.38410311127) | 10 | 3 | 8 | 58 | 1 | |||
| 57781 | 191750 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1625 Owen St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014226.3037 | 2107625.43664 | 37.7679377605556 | -122.394066169617 | (37.7679377605556, -122.394066169617) | 14 | 3 | 9 | 310 | 20 | |||
| 58196 | 191788 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014523.52915 | 2109561.35939 | 37.7732698904311 | -122.393173570904 | (37.7732698904311, -122.393173570904) | 14 | 3 | 9 | 310 | 20 | |||
| 59382 | 191787 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014542.42986 | 2109577.51132 | 37.7733152900047 | -122.393109320651 | (37.7733152900047, -122.393109320651) | 14 | 3 | 9 | 310 | 20 | |||
| 64755 | 191751 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1625 Owen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014208.40259 | 2107643.9572 | 37.7679876189722 | -122.394129384761 | (37.7679876189722, -122.394129384761) | 14 | 3 | 9 | 310 | 20 | |||
| 66904 | 191781 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014648.08638 | 2109681.02435 | 37.7736053825023 | -122.392751080204 | (37.7736053825023, -122.392751080204) | 14 | 3 | 9 | 310 | 20 | |||
| 74597 | 137899 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1826 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003438.8883 | 2115172.4505 | 37.7880545249544 | -122.431917559394 | (37.7880545249544, -122.431917559394) | 13 | 9 | 11 | 29490 | 27 | |||
| 75355 | 191792 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6014433.64417 | 2109472.38014 | 37.7730205794622 | -122.393478269306 | (37.7730205794622, -122.393478269306) | 14 | 3 | 9 | 310 | 20 | |||
| 81810 | 191753 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1625 Owen St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014169.77832 | 2107683.74351 | 37.7680947165235 | -122.394265768774 | (37.7680947165235, -122.394265768774) | 14 | 3 | 9 | 310 | 20 | |||
| 82044 | 191778 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6014723.18737 | 2109748.72437 | 37.7737954425503 | -122.392496028863 | (37.7737954425503, -122.392496028863) | 14 | 3 | 9 | 310 | 20 | |||
| 97158 | 191777 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6014740.46792 | 2109768.27161 | 37.7738500745454 | -122.392437619717 | (37.7738500745454, -122.392437619717) | 14 | 3 | 9 | 310 | 20 | |||
| 99506 | 140644 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 51 SHRADER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997268.3746 | 2110231.7749 | 37.7741369913881 | -122.452909578762 | (37.7741369913881, -122.452909578762) | 15 | 5 | 2 | 29492 | 16 | |||
| 105680 | 191780 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014685.91527 | 2109714.72868 | 37.7737000280525 | -122.392622581484 | (37.7737000280525, -122.392622581484) | 14 | 3 | 9 | 310 | 20 | |||
| 113246 | 191789 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6014504.606 | 2109544.08712 | 37.7732214133716 | -122.393237820291 | (37.7732214133716, -122.393237820291) | 14 | 3 | 9 | 310 | 20 | |||
| 113590 | 191784 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6014596.088 | 2109628.55041 | 37.7734584125988 | -122.392927279876 | (37.7734584125988, -122.392927279876) | 14 | 3 | 9 | 310 | 20 | |||
| 117266 | 191776 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014758.24285 | 2109784.44646 | 37.7738954741324 | -122.392377264405 | (37.7738954741324, -122.392377264405) | 14 | 3 | 9 | 310 | 20 | |||
| 117334 | 224271 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1000 San Jose Ave | 105 | Front Yard : Yard | Tree | Private 2 | 23 | 6005045.997 | 2096959.12957 | 37.7381360499328 | -122.425060830014 | (37.7381360499328, -122.425060830014) | 2 | 7 | 5 | 63 | 7 | ||||
| 121151 | 191774 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014898.64334 | 2109922.28641 | 37.7742817473506 | -122.391901232578 | (37.7742817473506, -122.391901232578) | 14 | 3 | 9 | 310 | 20 | |||
| 121830 | 191747 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014448.72859 | 2107389.57546 | 37.7673024974417 | -122.393280314144 | (37.7673024974417, -122.393280314144) | 14 | 3 | 9 | 310 | 20 | |||
| 130514 | 32014 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 466 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 7 | Permit Number 45606 | 5984414.61405 | 2112665.59366 | 37.7800745778358 | -122.497552043469 | (37.7800745778358, -122.497552043469) | 11 | 6 | 2 | 55 | 26 | |
| 132156 | 191752 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1625 Owen St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014185.50439 | 2107669.58575 | 37.7680567165689 | -122.394210382216 | (37.7680567165689, -122.394210382216) | 14 | 3 | 9 | 310 | 20 | |||
| 132334 | 217818 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1x Junipero Serra Blvd | 5 | Median : Yard | Tree | DPW 1 | 37 | 5991630.64581 | 2095733.14753 | 37.7340028647425 | -122.471354673377 | (37.7340028647425, -122.471354673377) | 1 | 8 | 4 | 59 | 40 | ||||
| 132590 | 191744 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014515.2981 | 2107319.93362 | 37.7671149743997 | -122.393045184606 | (37.7671149743997, -122.393045184606) | 14 | 3 | 9 | 310 | 20 | |||
| 138824 | 191742 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014584.87581 | 2107249.62911 | 37.7669257984189 | -122.392799604924 | (37.7669257984189, -122.392799604924) | 14 | 3 | 9 | 310 | 20 | |||
| 139649 | 191745 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014498.46709 | 2107339.22822 | 37.7671670181599 | -122.393104751185 | (37.7671670181599, -122.393104751185) | 14 | 3 | 9 | 310 | 20 | |||
| 159735 | 191783 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6014612.48499 | 2109646.15421 | 37.7735076594811 | -122.392871791707 | (37.7735076594811, -122.392871791707) | 14 | 3 | 9 | 310 | 20 | |||
| 161302 | 191779 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6014704.8611 | 2109733.12142 | 37.773751582593 | -122.39255833122 | (37.773751582593, -122.39255833122) | 14 | 3 | 9 | 310 | 20 | |||
| 167403 | 191775 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6014793.01139 | 2109819.89403 | 37.7739947358896 | -122.392259473006 | (37.7739947358896, -122.392259473006) | 14 | 3 | 9 | 310 | 20 | |||
| 167769 | 224273 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1300 San Jose Ave | 48 | Front Yard : Yard | Tree | Private 2 | 20 | 6003378.57618 | 2095536.03413 | 37.7341342224082 | -122.430724411296 | (37.7341342224082, -122.430724411296) | 2 | 7 | 5 | 63 | 7 | ||||
| 171051 | 191749 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1625 Owen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014300.87385 | 2107548.11125 | 37.7677295863811 | -122.393802824746 | (37.7677295863811, -122.393802824746) | 14 | 3 | 9 | 310 | 20 | |||
| 171619 | 191743 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014558.87733 | 2107278.73682 | 37.7670042777465 | -122.39289156689 | (37.7670042777465, -122.39289156689) | 14 | 3 | 9 | 310 | 20 | |||
| 171631 | 191786 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014558.79858 | 2109593.71449 | 37.773360689586 | -122.393053832481 | (37.773360689586, -122.393053832481) | 14 | 3 | 9 | 310 | 20 | |||
| 172856 | 191746 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1699 Owen St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014483.07335 | 2107354.88341 | 37.767209148715 | -122.393159091815 | (37.767209148715, -122.393159091815) | 14 | 3 | 9 | 310 | 20 | |||
| 173555 | 224272 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1000 San Jose Ave | 118 | Front Yard : Yard | Tree | Private 2 | 8 | 6005007.01889 | 2096875.50161 | 37.737904224505 | -122.425189647979 | (37.737904224505, -122.425189647979) | 2 | 7 | 5 | 63 | 7 | ||||
| 182202 | 22107 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 3550 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015967.58634 | 2099056.56935 | 37.744506090079 | -122.387445367011 | (37.744506090079, -122.387445367011) | 10 | 3 | 8 | 58 | 1 | |||
| 187801 | 191782 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 210 Channel | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014630.86236 | 2109664.27803 | 37.7735584441913 | -122.392809489369 | (37.7735584441913, -122.392809489369) | 14 | 3 | 9 | 310 | 20 | |||
| 189142 | 224275 | DPW Maintained 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 261 | 1300 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 45 | 6003325.50221 | 2095516.54438 | 37.7340777009229 | -122.43090651414 | (37.7340777009229, -122.43090651414) | 2 | 7 | 5 | 63 | 7 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );