trees

42 rows where Neighborhoods (old) = 40 and qLegalStatus_id = 8 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

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)
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
6335 262305 Property Tree 8 Casuarina cunninghamiana :: Horsetail pine 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
12060 101900 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100 Ocean Ave 1 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
13832 259913 Property Tree 8 Pinus radiata :: Monterey Pine 15 23 Cresta Vista Dr 1 Back Yard : Yard Tree Private 2       3x3   5995254 2096176 37.7354277647167 -122.45885975654 (37.7354277647167, -122.45885975654) 9 7 4 59 40
20402 257888 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 155X Magellan Ave 1 Front Yard : Yard Tree MTA 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
20664 121198 Property Tree 8 Cordyline australis :: Dracena Palm 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 40
30075 100070 Property Tree 8 Tree(s) :: 17 331 Serrano Dr 1 Front Yard : Yard Tree Private 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
30542 98548 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 132 Hamerton Ave 1 Front Yard : Yard Tree Private 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
44661 102745 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 222 Moncada Way 1 Front Yard : Yard Tree Private 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
89692 122453 Property Tree 8 Pinus radiata :: Monterey Pine 15 217 San Marcos Ave 1 Back Yard : Yard Tree Private 2       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209) 1 8 4 29491 40
97665 121104 Property Tree 8 Pinus radiata :: Monterey Pine 15 477 Myra Way 1 Back Yard : Yard Tree Private 2       3x3   5997298 2097021 37.7378652095891 -122.45185385939 (37.7378652095891, -122.45185385939) 9 7 4 59 40
103546 113379 Property Tree 8 Fagus sylvatica :: European Beech 272 140 CASTENADA AVE 1 Front Yard : Yard Tree Private 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
105992 258053 Property Tree 8 Pinus radiata :: Monterey Pine 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
129920 106227 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 38 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997884 2095808.5 37.7345695210024 -122.44974042874 (37.7345695210024, -122.44974042874) 9 7 4 59 40
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
131293 254124 Property Tree 8 Pinus radiata :: Monterey Pine 15 365 Edgehill Way 1 Back Yard : Cutout Tree Private 2       3x3   5994964 2098864 37.7427916745102 -122.460057057879 (37.7427916745102, -122.460057057879) 1 8 4 59 40
133884 114949 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 1 unknown : Yard Tree DPW 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
139843 108680 Property Tree 8 Juniperus chinensis :: Juniper 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree Private 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
148738 252848 Property Tree 8 Pinus halepensis :: Allepo Pine 330 99 Reposa Way 1 Back Yard : Yard Tree Private 2       3x3   5998022 2098104 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965) 9 7 4 59 40
150726 106275 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 42 Stanford Heights Ave 1 Back Yard : Yard Tree Private 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
171323 253471 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 17 Valletta Ct 1 Side Yard : Yard Tree Private 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
176836 102639 Property Tree 8 Pinus radiata :: Monterey Pine 15 251 Dorado Ter 1 Back Yard : Yard Tree Private 2           5994312.1 2092840.7 37.7262156610351 -122.461874461465 (37.7262156610351, -122.461874461465) 9 8 4 28861 40
192549 98880 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 101 Lansdale Ave 1 Front Yard : Yard Tree Private 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
39981 256672 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 Kenwood Way 11 Back Yard : Yard Tree Private 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
54121 101901 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 1100 Ocean Ave 2 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
75714 114950 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 2 unknown : Yard Tree DPW 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
107546 112377 Property Tree 8 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 3 Sidewalk: Curb side : Cutout Tree MTA 3     36     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
13075 261490 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
128219 101903 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 4 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1189 261265 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 5 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
191552 101904 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 5 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
144842 101905 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 6 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40

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