59 rows where Neighborhoods (old) = 40 and qSpecies_id = 63

View and edit SQL

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)
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
7002 262493 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
9305 251160 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
10438 262492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
12567 211070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 7 Median : Yard Tree DPW 1     24     5995378.92982 2093188.43217 37.7272318087773 -122.458211668947 (37.7272318087773, -122.458211668947) 9 7 4 28861 40
17261 261487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
20964 217820 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1x Junipero Serra Blvd 7 Median : Yard Tree DPW 1     3     5991627.31768 2095659.97546 37.7338017601455 -122.471360849935 (37.7338017601455, -122.471360849935) 1 8 4 59 40
22712 101030 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 4 Median : Yard Tree DPW 1     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
23455 97490 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 7 Median : Cutout Tree Private 2     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
28006 211079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2319 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 3ft   5992294.50858 2099658.84702 37.7448202223807 -122.469345163475 (37.7448202223807, -122.469345163475) 1 8 4 29491 40
28620 211073 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 5 Median : Yard Tree DPW 1     26     5995385.83715 2093544.41078 37.7282096371561 -122.458213544022 (37.7282096371561, -122.458213544022) 9 7 4 28861 40
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
30931 211072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 2 Median : Yard Tree DPW 1     35     5995382.34021 2093429.07469 37.7278927511259 -122.458217288807 (37.7278927511259, -122.458217288807) 9 7 4 28861 40
31868 13401 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 344 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999579.163416 2097433.156503 37.7391272835542 -122.443996396446 (37.7391272835542, -122.443996396446) 9 7 4 59 40
32960 121406 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10X Dorchester Way 2 Median : Cutout Tree DPW 1       8x30   5994075 2098171 37.7408376984389 -122.463080674317 (37.7408376984389, -122.463080674317) 1 8 4 59 40
33425 99460 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 7 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
36279 99451 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
49979 99473 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
50718 211068 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 1 Median : Yard Tree DPW 1     35     5995376.89131 2092998.0023 37.7267088170477 -122.4582049393 (37.7267088170477, -122.4582049393) 9 7 4 28861 40
60529 211074 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 5 Median : Yard Tree DPW 1     30     5995392.34643 2093881.33119 37.7291351132945 -122.458215416413 (37.7291351132945, -122.458215416413) 9 7 4 28861 40
62980 211065 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 400x Miramar Ave 1 Median : Yard Tree DPW 1     25     5995367.47216 2092431.62053 37.7251531275117 -122.458196526171 (37.7251531275117, -122.458196526171) 9 7 4 28861 40
67798 211064 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 300x Miramar Ave 3 Median : Yard Tree DPW 1     35     5995363.79151 2092232.49572 37.7246061670234 -122.458194844436 (37.7246061670234, -122.458194844436) 9 7 4 28861 40
70023 97489 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
70780 211076 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700x Miramar Ave 2 Median : Yard Tree DPW 1     74     5995394.80602 2094076.5012 37.7296711442905 -122.458221033586 (37.7296711442905, -122.458221033586) 9 7 4 28861 40
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
74864 99487 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 4 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
82478 98836 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 6 Sidewalk: Property side : Yard Tree DPW 1           5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
87097 211066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 2 Median : Yard Tree DPW 1     36     5995372.70371 2092704.86629 37.7259036953978 -122.458198208802 (37.7259036953978, -122.458198208802) 9 7 4 28861 40
99546 211067 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 5 Median : Yard Tree DPW 1     39     5995372.66361 2092795.985 37.7261538831809 -122.458204939322 (37.7261538831809, -122.458204939322) 9 7 4 28861 40
101918 99474 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
105224 211077 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100x Idora Ave 9 Median : Yard Tree DPW 1     9 Width 9ft   5995433.61803 2099390.76131 37.7442650295015 -122.458471384168 (37.7442650295015, -122.458471384168) 1 8 4 59 40
105788 218299 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Ardenwood Way 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 8ft   5991311.90242 2096390.21304 37.7357885567818 -122.472504543874 (37.7357885567818, -122.472504543874) 1 8 4 29491 40
111527 99477 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
118486 100845 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
126413 211063 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 333 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 4ft   5994231.86901 2100876.38212 37.7482750327754 -122.462734494413 (37.7482750327754, -122.462734494413) 1 8 4 29491 40
135343 30050 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900X Junipero Serra Blvd 1 Median : Cutout Tree DPW 1     3 3X3   5991182.41456 2091161.54655 37.7214244519661 -122.472571141372 (37.7214244519661, -122.472571141372) 9 8 4 64 40
136927 211081 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999513.42858 2095531.79881 37.7339028547188 -122.444087092249 (37.7339028547188, -122.444087092249) 9 7 4 63 40
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
139390 99472 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
142912 99486 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
145613 211069 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 3 Median : Yard Tree DPW 1     29     5995377.19569 2093059.06381 37.7268764947539 -122.458208304568 (37.7268764947539, -122.458208304568) 9 7 4 28861 40
146926 18112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X Portola Dr 1 Median : Cutout Tree DPW 1     24 10   5995262.3028257 2098061.6496673 37.7406057719366 -122.458967536918 (37.7406057719366, -122.458967536918) 1 7 4 59 40
148910 110143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1130X PORTOLA DR 3 Sidewalk: Curb side : Yard Tree DPW 1       3x3   5994964 2098019 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
153642 107347 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1126X PORTOLA DR 1 Median : Cutout Tree DPW 1     68     5994964 2098019 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
160036 253982 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 438X Detroit St 1 Unaccepted Street : Yard Tree Private 2       10x10   5999326 2094622 37.7313940668699 -122.444669716777 (37.7313940668699, -122.444669716777) 9 7 4 59 40
161389 211071 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 8 Median : Yard Tree DPW 1     25     5995380.09454 2093218.25605 37.727313764897 -122.458209800169 (37.727313764897, -122.458209800169) 9 7 4 28861 40
161917 99457 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
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
163251 97485 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
164258 253422 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 1 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
170298 211082 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 843 Detroit St 7 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   5999417.62854 2095618.00896 37.7341341018996 -122.444424494503 (37.7341341018996, -122.444424494503) 9 7 4 59 40
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
184680 256643 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 2 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
186578 211080 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5999525.10685 2095532.7271 37.7339060697915 -122.444046783738 (37.7339060697915, -122.444046783738) 9 7 4 63 40
188497 99458 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
193394 99455 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
193872 18113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X PORTOLA DR 2 Median : Cutout Tree DPW 1     24 10   5995249 2098057 37.7405922403942 -122.459013196083 (37.7405922403942, -122.459013196083) 1 7 4 59 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)
);