56 rows where Fire Prevention Districts = 2 and qSpecies_id = 47

View and edit SQL

Fire Prevention Districts

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)
21600 105136 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175X ESMERALDA AVE 2 unknown : Yard Tree DPW 1           6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
22890 50289 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
25754 47111 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.7409195061747 -122.418109646545 (37.7409195061747, -122.418109646545) 2 7 7 28859 2
32735 40449 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 255 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47061 6008102.60669454 2097399.44811028 37.7395172589666 -122.414523716357 (37.7395172589666, -122.414523716357) 2 7 7 28859 2
40263 227676 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 427 Valley St 1 Sidewalk: Curb side : Yard Tree Private 2     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762) 2 7 5 63 22
42446 52384 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 36TA MARINA Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM     Permit Number 48509 6005730.58900637 2097520.8738626 37.7397171218166 -122.422733759035 (37.7397171218166, -122.422733759035) 2 7 7 28859 2
47586 57377 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3505 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006157.87748572 2102561.9990288 37.7535830045092 -122.421614323469 (37.7535830045092, -122.421614323469) 2 4 5 28859 19
47837 227688 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 269 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6007769.10714 2097866.49845 37.7407809344798 -122.41570987722 (37.7407809344798, -122.41570987722) 2 7 7 28859 2
54078 52269 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48434 6005520.49766263 2101354.49181367 37.7502315077339 -122.423732674774 (37.7502315077339, -122.423732674774) 2 4 5 28859 19
56832 227680 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1541 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6003988.60954 2099295.31119 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577) 2 7 5 63 22
58452 101254 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3700X Cesar Chavez St 1 Front Yard : Yard Tree DPW 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
65610 237552 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 102 Hancock St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003566.97457 2105097.88602 37.7603995118464 -122.430755182518 (37.7603995118464, -122.430755182518) 2 4 5 28862 3
71117 52492 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 390ON GATES Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48601 6008184.68107457 2096494.82661811 37.7370379770988 -122.414175953506 (37.7370379770988, -122.414175953506) 2 7 7 28859 2
73352 34348 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 330 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38106 6004294.50938701 2096370.47715627 37.7364772644099 -122.427617172202 (37.7364772644099, -122.427617172202) 2 7 5 63 7
76454 227670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005513.92482 2101330.09926 37.7501641603604 -122.423753669923 (37.7501641603604, -122.423753669923) 2 4 5 28859 19
77195 237551 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 102 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003586.068 2105101.14828 37.7604095509682 -122.430689380017 (37.7604095509682, -122.430689380017) 2 4 5 28862 3
78182 113478 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100x ESMERALDA AVE 5 Unaccepted Street : Yard Tree DPW 1     8     6006917 2098966 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398) 2 7 7 28859 2
82654 116655 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
84280 50293 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
84866 227691 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 309 Bocana St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   6006868.92044 2097195.64462 37.7388882743696 -122.418774826116 (37.7388882743696, -122.418774826116) 2 7 7 28859 2
87369 81868 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3012-3014 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52207 6009486.0303434 2101043.89087343 37.749601722793 -122.409997630916 (37.749601722793, -122.409997630916) 2 4 7 28859 19
87869 116654 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
88904 116681 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100 Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
89012 227683 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 923 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007409.88053 2101914.88747 37.7518767015549 -122.417238758882 (37.7518767015549, -122.417238758882) 2 4 7 28859 19
89527 50288 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
92382 47550 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1681 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787) 2 7 5 63 22
93754 227689 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 84 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008214.29979 2099586.39862 37.7455284159971 -122.41429222281 (37.7455284159971, -122.41429222281) 2 7 7 28859 2
102941 227682 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008186.7931 2096476.12564 37.7369867469298 -122.41416732858 (37.7369867469298, -122.41416732858) 2 7 7 28859 2
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
107721 23670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 317 Virginia Ave 1 Median : Cutout Tree DPW 1     3 12   6006937.9415449 2098264.8464559 37.7418279505329 -122.41861198258 (37.7418279505329, -122.41861198258) 2 7 7 28859 2
112832 50290 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113972 50292 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
118985 227671 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 60 Front Yard : Yard Tree Private 2     10     6005087.18528 2097058.71456 37.7384118144577 -122.424925504521 (37.7384118144577, -122.424925504521) 2 7 5 63 7
121679 227674 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 83 Front Yard : Yard Tree Private 2     15     6005065.10158 2097012.05309 37.7382824451638 -122.424998540269 (37.7382824451638, -122.424998540269) 2 7 5 63 7
123108 227677 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003907.02908 2099270.15617 37.7444171939021 -122.429163548878 (37.7444171939021, -122.429163548878) 2 7 5 63 22
127819 227694 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 239 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999877.66163 2104769.07166 37.7592869569347 -122.443491144794 (37.7592869569347, -122.443491144794) 2 4 5 28862 3
129532 52497 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 371 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48606 6007135.79724675 2096038.97616324 37.7357273409345 -122.417770123047 (37.7357273409345, -122.417770123047) 2 7 7 28859 2
130752 1383 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2550X Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X2   6002248.65699 2096984.18535 37.7380464314256 -122.434734413124 (37.7380464314256, -122.434734413124) 2 7 5 63 7
134216 68097 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 49 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.7468442446896 -122.414234251858 (37.7468442446896, -122.414234251858) 2 7 7 28859 2
134621 227679 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003556.92712 2099495.03666 37.7450148383554 -122.430390170187 (37.7450148383554, -122.430390170187) 2 7 5 63 22
137505 34621 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 370 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3   Permit Number 778228 6003497.10528776 2099542.95496323 37.7451430220882 -122.430600441889 (37.7451430220882, -122.430600441889) 2 7 5 63 22
137873 227692 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 75 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006684.36987 2096973.81613 37.7382687898828 -122.419397184857 (37.7382687898828, -122.419397184857) 2 7 7 28859 2
139775 51442 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 775 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.416865768693 (37.7334476580973, -122.416865768693) 2 7 7 28859 2
141197 227672 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 62 Front Yard : Yard Tree Private 2     15     6005095.2123 2097053.48648 37.7383979127325 -122.424897379118 (37.7383979127325, -122.424897379118) 2 7 5 28859 7
142493 227693 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002979.94012 2100929.17253 37.7489199393117 -122.432487701248 (37.7489199393117, -122.432487701248) 2 4 5 28862 22
155190 227690 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 307 Bocana St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6006885.1558 2097215.40267 37.7389434396991 -122.418720092463 (37.7389434396991, -122.418720092463) 2 7 7 28859 2
156310 227675 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 104 Front Yard : Yard Tree Private 2     27     6005040.40727 2096975.56438 37.7381808604543 -122.425081325568 (37.7381808604543, -122.425081325568) 2 7 5 63 7
157287 115975 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 100 SAN JOSE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006168 2102576 37.7536220187283 -122.421580311855 (37.7536220187283, -122.421580311855) 2 4 5 28859 19
174228 227684 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2560 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002253.36783 2096984.49578 37.7380475512412 -122.434718147625 (37.7380475512412, -122.434718147625) 2 7 5 63 7
175565 248189 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 216 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     11     6007400.67054 2098728.2959 37.7431265201804 -122.417044843446 (37.7431265201804, -122.417044843446) 2 7 7 28859 2
176307 227678 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6003889.89165 2099268.52237 37.7444117377113 -122.429222690078 (37.7444117377113, -122.429222690078) 2 7 5 63 22
181040 227673 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 64 Front Yard : Yard Tree Private 2     12     6005078.09924 2097049.53511 37.7383860965292 -122.424956266738 (37.7383860965292, -122.424956266738) 2 7 5 63 7
185212 63714 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.415573763175 (37.7473672046192, -122.415573763175) 2 7 7 28859 2
187678 48774 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 629 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684) 2 7 7 28859 2
192707 49012 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2002 12:00:00 AM     Permit Number 46198 6003561.60300767 2099494.42119752 37.7450134133041 -122.430373957908 (37.7450134133041, -122.430373957908) 2 7 5 63 22
193338 50291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22

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