54 rows where qSiteInfo = "Front Yard : Yard" and qSpecies_id = 63

View and edit SQL

PlotSize

qSiteInfo

  • Front Yard : Yard · 54
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)
2154 234510 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 20 Front Yard : Yard Tree Private 2     15     6004874.94559 2096454.63294 37.7367411519672 -122.425616344829 (37.7367411519672, -122.425616344829) 2 7 5 28859 2
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
11808 247102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 20 Front Yard : Yard Tree Private 2     35     6002745.76405 2098754.96889 37.7429368028052 -122.43314215589 (37.7429368028052, -122.43314215589) 2 7 5 63 22
19749 234503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1000 San Jose Ave 39 Front Yard : Yard Tree Private 2     2     6005117.95051 2097175.77056 37.7387349615553 -122.424827458621 (37.7387349615553, -122.424827458621) 2 7 5 63 7
20818 247070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 6 Front Yard : Yard Tree Private 2     24     6002744.91385 2098422.48032 37.7420238182333 -122.433121344697 (37.7420238182333, -122.433121344697) 2 7 5 63 22
22210 111263 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     36     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
22573 105838 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 39X Bonview St 1 Front Yard : Yard Tree DPW 1     15     6007716.90579 2099172.41141 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151) 2 7 7 28859 2
22744 132175 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 Chestnut St 3 Front Yard : Yard Tree Private 2     49     6006452.3729 2120433.08861 37.8026692893229 -122.421865242911 (37.8026692893229, -122.421865242911) 5 9 1 28858 32
24668 97534 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 203 Surrey St 1 Front Yard : Yard Tree Private 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
25732 116996 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 606x FULTON ST   Front Yard : Yard Tree Private 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
28896 101032 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 6 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
37367 194451 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 930 Kansas St 1 Front Yard : Yard Tree Private 2     29     6011573.12502 2104017.28324 37.7578827599862 -122.402989455212 (37.7578827599862, -122.402989455212) 10 3 8 28856 29
38246 111524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
42925 256615 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1541x Montgomery St 1 Front Yard : Yard Tree DPW 1 DPW for City Agency         6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
60691 111521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 16 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
60884 247108 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 26 Front Yard : Yard Tree Private 2     48     6002704.67605 2098786.321 37.7430205575564 -122.433286466502 (37.7430205575564, -122.433286466502) 2 7 5 63 22
62583 234511 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 59 Front Yard : Yard Tree Private 2     5 Width 10ft   6003237.34595 2095470.24367 37.7339455743229 -122.431207993878 (37.7339455743229, -122.431207993878) 2 7 5 63 7
63289 111517 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 12 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
67373 247069 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 5 Front Yard : Yard Tree Private 2     25     6002737.44051 2098436.60323 37.7420621725331 -122.433148193957 (37.7420621725331, -122.433148193957) 2 7 5 63 22
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 5 63 22
69354 111518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 13 Front Yard : Yard Tree DPW 1     27     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
71037 132174 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111 Chestnut St 1 Front Yard : Yard Tree Private 2     52     6006441.86345 2120416.15353 37.8026221972261 -122.42190040729 (37.8026221972261, -122.42190040729) 5 9 1 28858 32
73422 234509 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 9 Front Yard : Yard Tree Private 2     25     6004750.38207 2096347.45133 37.7364398161369 -122.426039387727 (37.7364398161369, -122.426039387727) 2 7 5 28859 2
74160 98835 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Front Yard : Yard Tree DPW 1           5995262 2098056.7 37.7405921639667 -122.458968225676 (37.7405921639667, -122.458968225676) 1 7 4 59 40
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
86615 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5159 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000808 2099903 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335) 2 4 5 63 22
88434 247104 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 22 Front Yard : Yard Tree Private 2     31     6002734.00484 2098778.85198 37.743001713153 -122.433184522069 (37.743001713153, -122.433184522069) 2 7 5 63 22
90813 111522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 17 Front Yard : Yard Tree DPW 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
92200 247144 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 14 Front Yard : Yard Tree Private 2     23     6003151.94767 2100099.93337 37.7466527951889 -122.431833698065 (37.7466527951889, -122.431833698065) 2 7 5 63 22
92432 247072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 8 Front Yard : Yard Tree Private 2     22     6002777.34907 2098440.51813 37.7420751857223 -122.433010482565 (37.7420751857223, -122.433010482565) 2 7 5 63 22
94885 247113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 31 Front Yard : Yard Tree Private 2     5     6002717.05441 2098681.21035 37.7427326503855 -122.433236156629 (37.7427326503855, -122.433236156629) 2 7 5 63 22
101832 247109 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 27 Front Yard : Yard Tree Private 2     55     6002712.35608 2098750.32101 37.7429221456486 -122.433257339272 (37.7429221456486, -122.433257339272) 2 7 5 63 22
101920 247071 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 7 Front Yard : Yard Tree Private 2     27     6002776.8237 2098415.08611 37.7420053254986 -122.433010482544 (37.7420053254986, -122.433010482544) 2 7 5 63 22
104488 234502 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3502 24th St 1 Front Yard : Yard Tree Private 2     27     6006115.28896 2102029.42996 37.7521182909488 -122.421723779538 (37.7521182909488, -122.421723779538) 2 4 5 28859 19
105900 234504 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 5 Front Yard : Yard Tree Private 2     16     6004845.11812 2096728.13188 37.7374904329363 -122.425738932323 (37.7374904329363, -122.425738932323) 2 7 5 63 7
106034 255453 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 Kiska Rd 1 Front Yard : Yard Tree Private 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
110008 111523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
119227 234505 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 7 Front Yard : Yard Tree Private 2     16     6004841.55243 2096717.56088 37.7374612058616 -122.425750508406 (37.7374612058616, -122.425750508406) 2 7 5 63 7
119760 247143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 13 Front Yard : Yard Tree Private 2     26     6003160.52798 2100099.92491 37.7466532583536 -122.431804027655 (37.7466532583536, -122.431804027655) 2 7 5 63 22
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 10 3 8 28856 29
137630 101035 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 9 Front Yard : Yard Tree DPW 1   09/03/2014 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
145279 247112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 30 Front Yard : Yard Tree Private 2     4     6002722.94518 2098688.33329 37.7427525424969 -122.433216296891 (37.7427525424969, -122.433216296891) 2 7 5 63 22
148503 111281 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 19 Front Yard : Yard Tree DPW 1     48     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
148660 234506 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 8 Front Yard : Yard Tree Private 2     24     6004826.97139 2096714.28402 37.737451384369 -122.425800688759 (37.737451384369, -122.425800688759) 2 7 5 63 7
150055 111519 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 14 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
161041 234512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 61 Front Yard : Yard Tree Private 2     12 Width 6ft   6003219.80457 2095456.80721 37.7339076867834 -122.431267680974 (37.7339076867834, -122.431267680974) 2 7 5 63 7
162124 101027 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 1 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
164309 233330 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 4053 20th St 9 Front Yard : Yard Tree Private 2     16 Width 3ft   6003355.15759 2104159.05112 37.7578096927712 -122.431420737491 (37.7578096927712, -122.431420737491) 2 4 5 28862 3
165845 234524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 671 Church St 22 Front Yard : Yard Tree Private 2     11 Width 3ft   6004318.84944 2105025.54229 37.7602434426069 -122.4281496397 (37.7602434426069, -122.4281496397) 2 4 5 28862 3
170429 253558 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1240 Wisconsin St 1 Front Yard : Yard Tree Private 2           6012830 2101639 37.7514226163546 -122.398475746389 (37.7514226163546, -122.398475746389) 10 3 8 28856 29
178118 101028 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 2 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
183860 111506 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     48     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7

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