3,247 rows where qSpecies_id = 22 sorted by Neighborhoods (old)

View and edit SQL

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) ▼
79454 6661 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 3 3X3   6016028.90772 2098318.24105 37.7424821883031 -122.387181838675 (37.7424821883031, -122.387181838675) 10 3 8 58 1
84341 25988 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1863 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/30/2015 07:57:00 AM 3 3X3   6013632.3496 2096491.11087 37.7373322628733 -122.395340517063 (37.7373322628733, -122.395340517063) 10 3 8 58 1
85697 190394 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012003.95277 2100904.28978 37.7493592086764 -122.401280708234 (37.7493592086764, -122.401280708234) 10 3 8 58 1
87374 190417 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 9 : Tree Private 2     2 Width 3ft   6017947.81444 2096878.13487 37.7386340225323 -122.380446690882 (37.7386340225323, -122.380446690882) 10 3 8 58 1
91012 25912 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1800 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6013918.7634 2096357.1856 37.7369804570868 -122.39434087026 (37.7369804570868, -122.39434087026) 10 3 8 58 1
91774 1409 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 79 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017424.8922659 2095259.7862555 37.7341614907893 -122.382142174898 (37.7341614907893, -122.382142174898) 10 3 8 58 1
91971 25985 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1899 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6013478.77373 2096605.16178 37.7376368803489 -122.395879493351 (37.7376368803489, -122.395879493351) 10 3 8 58 1
92214 4041 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012003.95277 2100904.28978 37.7493592086764 -122.401280708234 (37.7493592086764, -122.401280708234) 10 3 8 58 1
92574 190440 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1350 Evans Ave 7 : Tree DPW 1   03/30/2004 12:00:00 AM 4 Width 3ft   6016842.64833 2097703.08966 37.7408381367768 -122.384325304974 (37.7408381367768, -122.384325304974) 10 3 8 58 1
93797 6501 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 43 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2014 12:00:00 AM 3 3x3   6016955.42201 2097623.13701 37.7406248380039 -122.383929806075 (37.7406248380039, -122.383929806075) 10 3 8 58 1
94370 199668 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1903 Keith St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015186.9182 2093384.6973 37.728889017268 -122.389748698946 (37.728889017268, -122.389748698946) 10 3 8 58 1
94531 6552 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1275 Evans Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2004 12:00:00 AM 2 3x3   6017428.8317 2097149.87395 37.7393515124558 -122.382260003801 (37.7393515124558, -122.382260003801) 10 3 8 58 1
94639 6677 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1555X Evans Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3X3   6015913.3615039 2098275.7507256 37.7423591192364 -122.387578402998 (37.7423591192364, -122.387578402998) 10 3 8 58 1
96277 4037 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6011877.98748 2100898.05147 37.749335051069 -122.401715863223 (37.749335051069, -122.401715863223) 10 3 8 58 1
97528 6499 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 41 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3X3   6017004.32701 2097592.12501 37.7405423887708 -122.383758551012 (37.7405423887708, -122.383758551012) 10 3 8 58 1
97782 6473 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 3 3X3   6017566.13101 2097162.72001 37.7393943676917 -122.381786171981 (37.7393943676917, -122.381786171981) 10 3 8 58 1
98056 253068 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 420 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.00752 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757) 10 3 8 58 1
98228 190454 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 25 Pomona St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6014177.43025 2094543.7925 37.7320156265221 -122.393319675671 (37.7320156265221, -122.393319675671) 10 3 8 58 1
99616 6560 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1275 Evans Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/24/1998 12:00:00 AM 5 3X3   6017410.00107 2097164.07797 37.7393894737512 -122.38232610038 (37.7393894737512, -122.38232610038) 10 3 8 58 1
103633 113842 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1709 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6014555.91727 2094766.75575 37.7326488589531 -122.392026740166 (37.7326488589531, -122.392026740166) 10 3 8 58 1
103780 190449 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1498 Evans Ave 3 : Tree Private 2     2 Width 4ft   6016446.96027 2097998.11216 37.7416263215051 -122.385714016492 (37.7416263215051, -122.385714016492) 10 3 8 58 1
104256 25911 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1800 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/2014 12:00:00 AM 3 3X3   6013940.91022 2096342.20585 37.7369405568534 -122.394263249761 (37.7369405568534, -122.394263249761) 10 3 8 58 1
104375 113266 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 86 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM 1   Permit Number 774770 6012949.27071 2090610.02044 37.7211459795788 -122.397289961272 (37.7211459795788, -122.397289961272) 10 3 8 58 1
105833 25913 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1800 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6013897.73879 2096372.14264 37.7370203572955 -122.394414609241 (37.7370203572955, -122.394414609241) 10 3 8 58 1
106208 190415 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1799 Indiana St 2 : Tree Private 2     1 Width 5ft   6015204.21504 2100274.26045 37.7478073070623 -122.390170025934 (37.7478073070623, -122.390170025934)   3 8 58 1
107263 16534 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1420X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2004 12:00:00 AM 3 3X3   6016649.3386754 2097853.1412174 37.7412394571821 -122.385004155587 (37.7412394571821, -122.385004155587) 10 3 8 58 1
108157 6453 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1199 Evans Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2009 12:00:00 AM 3 3X3   6017908.60089 2096791.35092 37.7383935672065 -122.380576243601 (37.7383935672065, -122.380576243601) 10 3 8 58 1
108663 6633 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1495 Evans Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/1997 12:00:00 AM 1 3X3   6016378.18563 2097933.75245 37.7414457969989 -122.385947333025 (37.7414457969989, -122.385947333025) 10 3 8 58 1
108932 4040 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012395.8663751 2100931.7625375 37.7494565004832 -122.399927382488 (37.7494565004832, -122.399927382488) 10 3 8 58 1
109614 190427 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 25 : Tree Private 2     3 Width 3ft   6017659.5138 2097095.80959 37.7392158011555 -122.381458640414 (37.7392158011555, -122.381458640414) 10 3 8 58 1
110086 4046 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012224.99422 2100912.98992 37.7493954270713 -122.400516948208 (37.7493954270713, -122.400516948208) 10 3 8 58 1
112486 113851 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2x Bay View St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 4x4   6014504.33786 2094720.43082 37.7325187962993 -122.392201825578 (37.7325187962993, -122.392201825578) 10 3 8 58 1
112496 6424 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100X Evans Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 12:46:00 PM 3 3x3   6018234.67827 2096633.8011 37.7379789554566 -122.379437873653 (37.7379789554566, -122.379437873653) 10 3 8 58 1
112746 190410 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012317.26543 2100919.43782 37.7494182770353 -122.400198322911 (37.7494182770353, -122.400198322911) 10 3 8 58 1
114164 1392 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 22 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017289.0057302 2095457.8512491 37.7346978320202 -122.382625759658 (37.7346978320202, -122.382625759658) 10 3 8 58 1
114551 25992 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1845X Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013845.47996 2096331.56216 37.7369060264874 -122.394592451983 (37.7369060264874, -122.394592451983) 10 3 8 58 1
117504 201608 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 598 Innes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6020912.48689 2093230.64881 37.7287818667771 -122.369944109446 (37.7287818667771, -122.369944109446) 10 3 8 58 1
119850 190414 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 15 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012337.1891 2100920.23068 37.7494215649704 -122.400129481597 (37.7494215649704, -122.400129481597) 10 3 8 58 1
121661 190401 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 10 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012204.22169 2100912.2871 37.7493923387987 -122.400588731202 (37.7493923387987, -122.400588731202) 10 3 8 58 1
121676 96002 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1440 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 1 3x3 Permit Number 767657 6015789.5338 2093564.664 37.7294165684422 -122.387677946908 (37.7294165684422, -122.387677946908) 10 3 8 58 1
121742 1389 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017228.6912616 2095462.3520099 37.7347068580177 -122.382834602513 (37.7347068580177, -122.382834602513) 10 3 8 58 1
121803 113844 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1709 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 5x5   6014584.73732 2094746.59806 37.7325951100749 -122.391925692318 (37.7325951100749, -122.391925692318) 10 3 8 58 1
122442 190405 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 12 : Tree Private 2     4 Width 3ft   6012259.88232 2100916.21266 37.749406221625 -122.400396529894 (37.749406221625, -122.400396529894) 10 3 8 58 1
123216 6466 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2016 02:10:00 PM 3 5x3   6017691.37401 2097075.64601 37.7391621949376 -122.381347079263 (37.7391621949376, -122.381347079263) 10 3 8 58 1
123829 113852 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 1700x REVERE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014672 2094788 37.7327136355619 -122.391626895226 (37.7327136355619, -122.391626895226) 10 3 8 58 1
123869 192479 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100 Pennsylvania Ave 9 Sidewalk: Curb side : Yard Tree Private 2     1     6014497.46696 2101747.35421 37.7518128856693 -122.392716981507 (37.7518128856693, -122.392716981507) 10 3 8 28856 1
125115 202048 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 Exeter St 2 : Tree Private 2     1 Width 3ft   6012550.84641 2090927.25992 37.7219948649522 -122.398689459255 (37.7219948649522, -122.398689459255) 10 3 8 58 1
125835 192476 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100 Pennsylvania Ave 4 Sidewalk: Curb side : Yard Tree Private 2     1     6014495.23557 2101789.67403 37.7519289629698 -122.392727658282 (37.7519289629698, -122.392727658282) 10 3 8 28856 1
126303 190456 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1709 Revere Ave 5 : Tree Private 2     3 Width 5ft   6014599.96347 2094732.12435 37.7325562135041 -122.391872039683 (37.7325562135041, -122.391872039683) 10 3 8 58 1
126566 6481 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 24 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/2004 12:00:00 AM 3 3X3   6017370.51401 2097316.59001 37.7398060600402 -122.38247323921 (37.7398060600402, -122.38247323921) 10 3 8 58 1
126967 6602 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Evans Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   04/04/1997 12:00:00 AM 6 3X3   6016545.70943 2097925.30543 37.7414318727766 -122.385367499637 (37.7414318727766, -122.385367499637) 10 3 8 58 1
127414 87299 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 1 Back Yard : Yard Tree DPW 1     4   Permit Number 50312 6011851.38946 2100896.59511 37.7493295679091 -122.401807737936 (37.7493295679091, -122.401807737936) 10 3 8 58 1
128420 25986 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1889 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6013508.76181 2096582.47787 37.7375762633209 -122.395774220512 (37.7375762633209, -122.395774220512) 10 3 8 58 1
128815 4048 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012292.25603 2100918.21603 37.7494135277217 -122.40028472079 (37.7494135277217, -122.40028472079) 10 3 8 58 1
129940 113848 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2x Bay View St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6014558.02731 2094710.13283 37.7324935010709 -122.392015486932 (37.7324935010709, -122.392015486932) 10 3 8 58 1
130896 201605 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 570 Innes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6021066.69823 2093118.68379 37.7284828925695 -122.369403250859 (37.7284828925695, -122.369403250859) 10 3 8 58 1
131031 6656 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2004 12:00:00 AM 3 3X3   6016128.17059 2098243.97439 37.7422837636921 -122.38683343593 (37.7422837636921, -122.38683343593) 10 3 8 58 1
131884 6587 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1375 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2004 12:00:00 AM 3 3X3   6016853.0670442 2097574.0145522 37.7404842987312 -122.384280293448 (37.7404842987312, -122.384280293448) 10 3 8 58 1
132455 190457 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 38 Bridgeview Dr 1 : Tree Private 2     1 Width 3ft   6013965.07757 2095502.46045 37.7346361322527 -122.394120920368 (37.7346361322527, -122.394120920368) 10 3 8 58 1
132490 113847 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2x Bay View St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 4x4   6014575.04616 2094706.38407 37.7324841526011 -122.391956386193 (37.7324841526011, -122.391956386193) 10 3 8 58 1
132681 6658 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   10/17/2009 12:00:00 AM 3 3X3   6016095.55691 2098268.17698 37.7423484132627 -122.386947892648 (37.7423484132627, -122.386947892648) 10 3 8 58 1
134184 190446 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1201 Evans Ave 4 : Tree Private 2     4 Width 3ft   6017708.20702 2096943.20124 37.7387994573363 -122.381279670829 (37.7387994573363, -122.381279670829) 10 3 8 58 1
135121 98310 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1499@Newhall Evans Ave 2 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.27381 37.7417009175609 -122.386401389915 (37.7417009175609, -122.386401389915) 10 3 8 58 1
135801 190445 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1201 Evans Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017686.12557 2096959.12409 37.7388419592822 -122.381357125839 (37.7388419592822, -122.381357125839) 10 3 8 58 1
136972 6660 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 6 3X3   6016043.95648 2098306.88974 37.7424518532839 -122.38712901249 (37.7424518532839, -122.38712901249) 10 3 8 58 1
137038 6653 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2004 12:00:00 AM 3 3X3   6015990.464364 2098347.4229363 37.7425601868054 -122.38731680075 (37.7425601868054, -122.38731680075) 10 3 8 58 1
137426 102650 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1845X Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6013718.9 2096447.3 37.7372167805961 -122.395038202336 (37.7372167805961, -122.395038202336) 10 3 8 58 1
137638 201607 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 598 Innes Ave 2 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.83409 37.7287396409072 -122.369867514187 (37.7287396409072, -122.369867514187) 10 3 8 58 1
139917 190403 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012224.99422 2100912.98992 37.7493954270713 -122.400516948208 (37.7493954270713, -122.400516948208) 10 3 8 58 1
140123 6595 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Evans Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2000 12:00:00 AM 6 3X3   6016681.72094 2097824.21819 37.7411618315488 -122.384890173648 (37.7411618315488, -122.384890173648) 10 3 8 58 1
140748 6546 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1225X Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2013 12:00:00 AM 3 3x3   6017625.4418446 2096995.6120179 37.7389387975003 -122.381569480835 (37.7389387975003, -122.381569480835) 10 3 8 58 1
140790 108047 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1301 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3 3x3   6017036.14467 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928) 10 3 8 58 1
141738 113854 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1700x Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4   6014619.79287 2094788.95809 37.7327133682248 -122.391807456662 (37.7327133682248, -122.391807456662) 10 3 8 58 1
142045 190431 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 29 : Tree Private 2     2 Width 3ft   6017575.22197 2097158.85814 37.7393842657625 -122.381754470602 (37.7393842657625, -122.381754470602) 10 3 8 58 1
142354 190412 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 15 : Tree Private 2     4 Width 3ft   6012337.1891 2100920.23068 37.7494215649704 -122.400129481597 (37.7494215649704, -122.400129481597) 10 3 8 58 1
142998 16530 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1420X Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/2006 12:00:00 AM 3 3x3   6016649.3386754 2097853.1412174 37.7412394571821 -122.385004155587 (37.7412394571821, -122.385004155587) 10 3 8 58 1
143701 190430 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 28 : Tree Private 2     3 Width 3ft   6017590.10949 2097147.67735 37.7393543876054 -122.381702218193 (37.7393543876054, -122.381702218193) 10 3 8 58 1
143940 4049 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 14 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012317.26543 2100919.43782 37.7494182770353 -122.400198322911 (37.7494182770353, -122.400198322911) 10 3 8 58 1
146358 190393 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 6 : Tree Private 2     4 Width 3ft   6012003.95277 2100904.28978 37.7493592086764 -122.401280708234 (37.7493592086764, -122.401280708234) 10 3 8 58 1
146611 44254 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1375 Evans Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2001 12:00:00 AM     Permit Number 43687 6016852.68384064 2097573.05225711 37.7404816352752 -122.384281551427 (37.7404816352752, -122.384281551427) 10 3 8 58 1
146898 6625 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Evans Ave 8 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/24/1998 12:00:00 AM 6 3x3   6016564.1874 2097795.2525 37.7410757961225 -122.385294548421 (37.7410757961225, -122.385294548421) 10 3 8 58 1
147488 6596 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2000 12:00:00 AM 6 3X3   6016665.24254 2097836.86612 37.7411956487572 -122.384948031546 (37.7411956487572, -122.384948031546) 10 3 8 58 1
148867 190398 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012152.10777 2100910.47094 37.7493844454379 -122.400768815931 (37.7493844454379, -122.400768815931) 10 3 8 58 1
149014 6603 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Evans Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   04/04/1997 12:00:00 AM 6 3X3   6016522.05024 2097942.62587 37.7414781222237 -122.385450512434 (37.7414781222237, -122.385450512434) 10 3 8 58 1
149423 199873 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1446 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015749.8727 2093598.2658 37.7295066352884 -122.387817403955 (37.7295066352884, -122.387817403955) 10 3 8 58 1
150978 25990 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1845X Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013804.26931 2096361.31922 37.736985442024 -122.39473701982 (37.736985442024, -122.39473701982) 10 3 8 58 1
151139 4042 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X3   6012031.32912 2100905.98791 37.7493653986954 -122.401186158933 (37.7493653986954, -122.401186158933) 10 3 8 58 1
151776 190453 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1501 Evans Ave 5 : Tree Private 2     1 Width 3ft   6016075.66534 2098156.64839 37.7420410771473 -122.387008895444 (37.7420410771473, -122.387008895444) 10 3 8 58 1
152307 190409 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 14 : Tree Private 2     4 Width 3ft   6012317.26543 2100919.43782 37.7494182770353 -122.400198322911 (37.7494182770353, -122.400198322911) 10 3 8 58 1
152583 4045 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2014 12:00:00 AM 3 2X3   6012204.22169 2100912.2871 37.7493923387987 -122.400588731202 (37.7493923387987, -122.400588731202) 10 3 8 58 1
153497 6454 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1199 Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 02:46:00 PM 3 3X3   6017932.4783 2096773.48366 37.7383458248849 -122.380492444782 (37.7383458248849, -122.380492444782) 10 3 8 58 1
154747 190411 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 15 : Tree Private 2     4 Width 3ft   6012337.1891 2100920.23068 37.7494215649704 -122.400129481597 (37.7494215649704, -122.400129481597) 10 3 8 58 1
157135 201616 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 0 Innes Ct 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6021349.55513 2092801.07471 37.7276263098888 -122.368403462858 (37.7276263098888, -122.368403462858) 10 3 8 58 1
158482 6655 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 6 3X3   6016144.11034 2098231.69923 37.7422509411428 -122.38677746482 (37.7422509411428, -122.38677746482) 10 3 8 58 1
159633 6452 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1195 Evans Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   09/22/2012 12:00:00 AM 3 3X3   6017800.8785909 2096864.2340114 37.738587744527 -122.380953764206 (37.738587744527, -122.380953764206) 10 3 8 58 1
159727 113855 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1700x Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6014596.64898 2094806.77216 37.7327609972174 -122.391888716698 (37.7327609972174, -122.391888716698) 10 3 8 58 1
160700 190408 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 13 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012292.25603 2100918.21603 37.7494135277217 -122.40028472079 (37.7494135277217, -122.40028472079) 10 3 8 58 1
161969 6659 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2000 12:00:00 AM 3 3X3   6016081.5878 2098278.96345 37.7423772572113 -122.386996946162 (37.7423772572113, -122.386996946162) 10 3 8 58 1
162411 27243 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1877 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6013583.54144 2096526.75062 37.7374274075466 -122.395511766876 (37.7374274075466, -122.395511766876) 10 3 8 58 1
162905 6430 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100X Evans Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 12:48:00 PM 3 3x3   6018115.58754 2096722.72512 37.7382165545353 -122.379855810196 (37.7382165545353, -122.379855810196) 10 3 8 58 1

Next page

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