trees

60 rows where Neighborhoods (old) = 31 and qSpecies_id = 54

✎ 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)
10282 18081 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2967 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999746.4018 2114674.089 37.7864761362834 -122.444657035366 (37.7864761362834, -122.444657035366) 15 6 1 29490 31
11526 66368 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5 Cook St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 10   Permit Number 29490 5997440.3621 2113655.9431 37.7835487164216 -122.452561811691 (37.7835487164216, -122.452561811691) 15 6 1 54 31
13248 138690 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2838 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5999904.6577 2114405.5136 37.7857477274076 -122.444090205696 (37.7857477274076, -122.444090205696) 15 6 1 29490 31
22348 111433 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500X Presidio Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5999168.0016 2114897.9415 37.7870577541309 -122.446674260217 (37.7870577541309, -122.446674260217) 15 6 1 29490 31
24743 66562 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 144 Collins St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1991 12:00:00 AM 5   Permit Number 29750 5998095.4621 2113585.8052 37.7833936486138 -122.450290371551 (37.7833936486138, -122.450290371551) 15 6 1 54 31
25346 139115 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2613 POST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999526.5436 2113598.8751 37.7835113303016 -122.445340349757 (37.7835113303016, -122.445340349757) 15 6 1 29490 31
30164 138611 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1711 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6000013.0072 2114911.1445 37.7871422388637 -122.443751687038 (37.7871422388637, -122.443751687038) 15 6 1 29490 31
35064 138707 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2874 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999741.1485 2114383.1871 37.7856770956012 -122.444654293951 (37.7856770956012, -122.444654293951) 15 6 1 29490 31
39177 141081 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 190 Commonwealth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996587.7084 2113030.7088 37.7817830987642 -122.455466443539 (37.7817830987642, -122.455466443539) 11 6 1 54 31
43809 141086 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3370 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996653.0238 2112962.686 37.7816000737762 -122.45523556685 (37.7816000737762, -122.45523556685) 11 6 1 54 31
43953 138715 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2900 BUSH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999573.0166 2114358.1558 37.7855987705543 -122.445234179741 (37.7855987705543, -122.445234179741) 15 6 1 29490 31
45097 138716 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1609 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999594.5745 2114418.8648 37.7857666921726 -122.445163962127 (37.7857666921726, -122.445163962127) 15 6 1 29490 31
51977 141307 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 61 COOK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   5997486.7259 2113348.6561 37.7827076436193 -122.452379230189 (37.7827076436193, -122.452379230189) 15 6 1 54 31
53133 104353 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2594 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5999783.3073 2113692.3242 37.7837825709749 -122.444458768108 (37.7837825709749, -122.444458768108) 15 6 11 29490 31
53611 138739 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999270.4631 2114185.9407 37.7851086382869 -122.446268530298 (37.7851086382869, -122.446268530298) 15 6 1 29490 31
53873 106406 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 650 Presidio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 5x6   5999248.4097 2114351.2177 37.7855611862943 -122.446356721815 (37.7855611862943, -122.446356721815) 15 6 1 29490 31
61706 138607 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 512 PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999174.9019 2114851.0194 37.7869293124952 -122.446647009525 (37.7869293124952, -122.446647009525) 15 6 1 29490 31
71607 61078 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2590 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1983 12:00:00 AM 13   Permit Number 20915 5999806.8161 2113697.9026 37.7837992291467 -122.444377837774 (37.7837992291467, -122.444377837774) 15 6 11 29490 31
83301 139365 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1590 LYON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999665.9385 2114296.9513 37.7854360225018 -122.444908296806 (37.7854360225018, -122.444908296806) 15 6 1 29490 31
83635 138691 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2844 BUSH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999863.2879 2114398.2903 37.7857255339984 -122.444232813751 (37.7857255339984, -122.444232813751) 15 6 1 29490 31
84048 57327 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2904 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1976 12:00:00 AM 17   Permit Number 16155 5999526.9274 2114356.6691 37.7855920575643 -122.445393527485 (37.7855920575643, -122.445393527485) 15 6 1 29490 31
84375 138765 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2736 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5999497.9358 2113999.1058 37.7846086267732 -122.445468109626 (37.7846086267732, -122.445468109626) 15 6 1 29490 31
93628 138626 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1707 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6000016.9472 2114873.7147 37.7870396910965 -122.443735365508 (37.7870396910965, -122.443735365508) 15 6 1 29490 31
101660 121389 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 2646 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5999473.1272 2113649.2828 37.7836466874196 -122.445528775036 (37.7836466874196, -122.445528775036) 15 6 11 29490 31
104054 53486 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1969 12:00:00 AM 14   Permit Number 6395 5996703.1102 2112969.116 37.7816206023811 -122.455062757544 (37.7816206023811, -122.455062757544) 11 6 1 54 31
106147 138717 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1607 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999600.5215 2114397.0591 37.7857071588413 -122.445141819006 (37.7857071588413, -122.445141819006) 15 6 1 29490 31
106261 13311 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2973X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     11 3X3   5999715.5386 2114669.4924 37.7864617540071 -122.444763483448 (37.7864617540071, -122.444763483448) 15 6 1 29490 31
111163 141074 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 COMMONWEALTH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5996533.2225 2113090.6095 37.7819444436309 -122.455659269227 (37.7819444436309, -122.455659269227) 11 6 1 54 31
111393 106408 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 650 Presidio Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 5x9   5999241.4715 2114391.8555 37.7856723708173 -122.446383650374 (37.7856723708173, -122.446383650374) 15 6 1 29490 31
111506 140932 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5 COOK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997447.8074 2113631.9151 37.783483168451 -122.452534319363 (37.783483168451, -122.452534319363) 15 6 1 54 31
113925 138744 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2965 Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999334.3934 2114268.2075 37.7853381723766 -122.446053271608 (37.7853381723766, -122.446053271608) 15 6 1 29490 31
115016 141083 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5996691.6039 2112967.4239 37.7816152962122 -122.45510244133 (37.7816152962122, -122.45510244133) 11 6 1 54 31
118617 111432 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500X Presidio Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5999166.6215 2114917.2623 37.7871107251509 -122.446680425702 (37.7871107251509, -122.446680425702) 15 6 1 29490 31
124768 138741 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2965 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999272.4455 2114257.3047 37.7853046984356 -122.446266807223 (37.7853046984356, -122.446266807223) 15 6 1 29490 31
125107 105341 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1407 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     12     6000167.325 2113807.8025 37.7841215482425 -122.4431385113 (37.7841215482425, -122.4431385113) 15 6 11 29490 31
127716 141087 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3380 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996639.8253 2112960.6555 37.781593741302 -122.45528108032 (37.781593741302, -122.45528108032) 11 6 1 54 31
127980 141088 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3380 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5996627.3037 2112959.9786 37.7815911642759 -122.455324349899 (37.7815911642759, -122.455324349899) 11 6 1 54 31
128147 138629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1705 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6000022.8572 2114841.5382 37.7869516798811 -122.443712605837 (37.7869516798811, -122.443712605837) 15 6 1 29490 31
129515 138745 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2965 Bush St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999354.2167 2114269.6942 37.7853433864461 -122.445984796208 (37.7853433864461, -122.445984796208) 15 6 1 29490 31
129892 58879 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2900 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1988 12:00:00 AM 13   Permit Number 25516 5999589.5873 2114362.4153 37.7856114118811 -122.445177156478 (37.7856114118811, -122.445177156478) 15 6 1 29490 31
134454 141080 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 192 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996588.0468 2113019.8793 37.7817533832417 -122.455464489898 (37.7817533832417, -122.455464489898) 11 6 1 54 31
137924 111431 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500X Presidio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5999170.7617 2114883.4508 37.7870181241285 -122.446663667925 (37.7870181241285, -122.446663667925) 15 6 1 29490 31
145096 47470 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2902 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM 14   Permit Number 45371 5999554.6801 2114357.1647 37.7855950025795 -122.445297547197 (37.7855950025795, -122.445297547197) 15 6 1 29490 31
147438 141078 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 196 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996588.0468 2112978.9303 37.7816409481265 -122.455461529406 (37.7816409481265, -122.455461529406) 11 6 1 54 31
148115 138743 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2965 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999307.6319 2114263.2516 37.7853230365302 -122.446145501349 (37.7853230365302, -122.446145501349) 15 6 1 29490 31
149607 138740 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 PRESIDIO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999265.5073 2114223.1094 37.7852104108131 -122.446288350453 (37.7852104108131, -122.446288350453) 15 6 1 29490 31
149785 141084 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 GEARY BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996679.0822 2112965.7318 37.7816099317752 -122.45514563789 (37.7816099317752, -122.45514563789) 11 6 1 54 31
152159 141085 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3370 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5996665.207 2112963.3629 37.7816026313548 -122.455193467958 (37.7816026313548, -122.455193467958) 11 6 1 54 31
152825 138608 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999173.5218 2114868.2702 37.78697659984 -122.446653025988 (37.78697659984, -122.446653025988) 15 6 1 29490 31
154652 106407 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 650 Presidio Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 5x6   5999244.445 2114365.5896 37.7856004213418 -122.446371472736 (37.7856004213418, -122.446371472736) 15 6 1 29490 31
155852 139407 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1311 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6000207.9303 2113507.632 37.7832996726996 -122.442976468383 (37.7832996726996, -122.442976468383) 15 6 1 29490 31
157472 138742 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2965 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999291.2776 2114261.7649 37.7853180204784 -122.446201975075 (37.7853180204784, -122.446201975075) 15 6 1 29490 31
158404 139083 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2512 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6000143.6633 2113744.4727 37.7839463117797 -122.443215821997 (37.7839463117797, -122.443215821997) 15 6 11 29490 31
165670 61337 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 650 Presidio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/1984 12:00:00 AM 10 5x6 Permit Number 21242 5999250.392 2114334.8634 37.7855163948709 -122.446348686743 (37.7855163948709, -122.446348686743) 15 6 1 29490 31
170716 141079 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 194 Commonwealth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5996588.7236 2113000.2508 37.7816995274116 -122.455460729419 (37.7816995274116, -122.455460729419) 11 6 1 54 31
172618 141075 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5996533.8993 2113075.3805 37.7819026676704 -122.455655826701 (37.7819026676704, -122.455655826701) 11 6 1 54 31
179334 141082 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 188 Commonwealth Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996586.3547 2113042.2151 37.7818146143415 -122.455471958556 (37.7818146143415, -122.455471958556) 11 6 1 54 31
180949 38058 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2844 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM 15   Permit Number 40253 5999884.3012 2114402.2303 37.7857375510232 -122.44416039717 (37.7857375510232, -122.44416039717) 15 6 1 29490 31
182958 138718 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1605 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999603.495 2114383.6783 37.7856705883683 -122.445130569247 (37.7856705883683, -122.445130569247) 15 6 1 29490 31
193272 113486 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 30 PRESIDIO AVE 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998975 2116473 37.7913714231174 -122.447455414162 (37.7913714231174, -122.447455414162) 13 6 1 29490 31

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