trees
4,014 rows where qSpecies_id = 40 sorted by qCaretaker_id
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65956 | 91928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X IRVING ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 2 | 3x3 | 5992070 | 2106573 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | 1 | 8 | 11 | 56 | 12 | ||
66760 | 86217 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2621 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2013 12:00:00 AM | 3 | 3x3 | 5988925.7787 | 2097455.0086 | 37.7385738093546 | -122.480832143468 | (37.7385738093546, -122.480832143468) | 1 | 8 | 3 | 29491 | 35 | ||
68223 | 4145 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3615-3623X Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | ||
68831 | 90655 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3434 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984935.16156 | 2110442.47233 | 37.7740010237847 | -122.495587241992 | (37.7740010237847, -122.495587241992) | 11 | 6 | 2 | 55 | 26 | ||
69685 | 23487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | ||
69966 | 4219 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004180.2435918 | 2100406.5432146 | 37.7475529128468 | -122.428299805317 | (37.7475529128468, -122.428299805317) | 2 | 4 | 5 | 63 | 22 | ||
71006 | 91974 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1332 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993346.580243 | 2106408.093833 | 37.7634126547611 | -122.466197713623 | (37.7634126547611, -122.466197713623) | 1 | 8 | 11 | 56 | 12 | ||
71498 | 27508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1325 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2000 12:00:00 AM | 12 | 3X3 | 6005854.22427 | 2101278.43596 | 37.750041509014 | -122.422573221603 | (37.750041509014, -122.422573221603) | 2 | 4 | 5 | 28859 | 19 | ||
71773 | 91951 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 751 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993470.629208 | 2106621.248866 | 37.7640050788828 | -122.465784159863 | (37.7640050788828, -122.465784159863) | 1 | 8 | 11 | 56 | 12 | ||
72243 | 91921 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1437 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991322.780388 | 2106547.676066 | 37.7636789379503 | -122.473207494478 | (37.7636789379503, -122.473207494478) | 1 | 8 | 11 | 56 | 12 | ||
72588 | 91955 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 621 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993869.320819 | 2106634.905708 | 37.7640655668897 | -122.464406205973 | (37.7640655668897, -122.464406205973) | 1 | 8 | 11 | 56 | 12 | ||
73305 | 86200 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.37374 | 2099150.307919 | 37.7432254380566 | -122.481147807758 | (37.7432254380566, -122.481147807758) | 1 | 8 | 3 | 29491 | 35 | ||
73934 | 104256 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
74131 | 91918 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1523 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991044.965492 | 2106538.159703 | 37.7636367187828 | -122.474167665735 | (37.7636367187828, -122.474167665735) | 1 | 8 | 11 | 56 | 12 | ||
74721 | 86519 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1309 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.436672 | 2106370.804533 | 37.7629823684162 | -122.485754041828 | (37.7629823684162, -122.485754041828) | 1 | 8 | 3 | 56 | 35 | ||
75697 | 85958 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988039.866297 | 2106434.861495 | 37.7631785479619 | -122.48455365718 | (37.7631785479619, -122.48455365718) | 1 | 8 | 3 | 56 | 35 | ||
75745 | 28262 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.48746 | 2088681.14992 | 37.7158076389797 | -122.399763675165 | (37.7158076389797, -122.399763675165) | 10 | 7 | 8 | 309 | 39 | ||
76883 | 27093 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 711 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6006091.08269 | 2093593.66537 | 37.7289542101608 | -122.421208528251 | (37.7289542101608, -122.421208528251) | 9 | 7 | 6 | 28861 | 5 | |||
77381 | 22521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 6600 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 02/20/1992 12:00:00 AM | 3 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | ||
78763 | 91982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1231 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993282.58983 | 2107104.747155 | 37.7653217893633 | -122.466469670891 | (37.7653217893633, -122.466469670891) | 11 | 8 | 11 | 56 | 12 | ||
78950 | 237033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 7 | : | Tree | DPW 1 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | 7 | 9 | 11 | 28852 | 10 | |||
79066 | 4120 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3435 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | 2 | 7 | 7 | 28859 | 2 | ||
81042 | 106983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1737-1795 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/01/2012 12:00:00 AM | 4 | 6003734.5 | 2114103.2 | 37.7851353863698 | -122.430818459211 | (37.7851353863698, -122.430818459211) | 13 | 9 | 11 | 29490 | 13 | |||
81435 | 103790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
82166 | 10703 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | 9 | 8 | 6 | 64 | 24 | |||
82755 | 86392 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1579 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988064.154428 | 2104565.481775 | 37.7580471547733 | -122.484332542242 | (37.7580471547733, -122.484332542242) | 1 | 8 | 3 | 56 | 35 | ||
83640 | 19331 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | 9 | 8 | 6 | 64 | 24 | ||
83709 | 9346 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 217 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1999 12:00:00 AM | 20 | 2X2 | 6000803.9441694 | 2098478.3891844 | 37.742067037249 | -122.439836590706 | (37.742067037249, -122.439836590706) | 2 | 7 | 5 | 63 | 7 | ||
84847 | 91967 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1372 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993355.537503 | 2106147.727912 | 37.7626982750081 | -122.466147811745 | (37.7626982750081, -122.466147811745) | 1 | 8 | 11 | 56 | 12 | ||
85557 | 91903 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1534 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991007.891482 | 2106576.913236 | 37.7637409778654 | -122.474298719903 | (37.7637409778654, -122.474298719903) | 11 | 8 | 11 | 56 | 12 | ||
85618 | 4234 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4013X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003806.79862 | 2100387.84018 | 37.7474804205949 | -122.429589821227 | (37.7474804205949, -122.429589821227) | 2 | 4 | 5 | 63 | 22 | ||
87403 | 91968 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1368 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993354.641777 | 2106173.764513 | 37.7627697130128 | -122.46615280189 | (37.7627697130128, -122.46615280189) | 1 | 8 | 11 | 56 | 12 | ||
88121 | 28255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.00542 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | 10 | 7 | 8 | 309 | 39 | ||
88978 | 4173 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3807X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 6005111.29038 | 2100461.84082 | 37.7477573856943 | -122.425084233943 | (37.7477573856943, -122.425084233943) | 2 | 4 | 5 | 63 | 22 | ||
89163 | 16435 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | ||
89932 | 104250 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
90185 | 85377 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
90435 | 91875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 700 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.7641372031802 | -122.465280687147 | (37.7641372031802, -122.465280687147) | 11 | 8 | 11 | 56 | 12 | ||
90957 | 4122 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3435 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | 2 | 7 | 7 | 28859 | 2 | ||
91734 | 91891 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1134 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992278.307636 | 2106620.430357 | 37.7639339819744 | -122.469907950407 | (37.7639339819744, -122.469907950407) | 11 | 8 | 11 | 56 | 12 | ||
91784 | 21664 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1759 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6004187.7527688 | 2114598.9985399 | 37.7865223945548 | -122.429285712666 | (37.7865223945548, -122.429285712666) | 13 | 9 | 11 | 29490 | 13 | |||
92688 | 91969 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1360 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993352.850325 | 2106225.837693 | 37.7629125889584 | -122.466162782208 | (37.7629125889584, -122.466162782208) | 1 | 8 | 11 | 56 | 12 | ||
94843 | 91971 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1342 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993348.819558 | 2106343.002353 | 37.7632340598338 | -122.466185238063 | (37.7632340598338, -122.466185238063) | 1 | 8 | 11 | 56 | 12 | ||
95145 | 196444 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200x Kansas St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | 10 | 3 | 8 | 28856 | 29 | |||
95920 | 91954 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 637 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993821.680813 | 2106633.273835 | 37.7640583399586 | -122.464570858995 | (37.7640583399586, -122.464570858995) | 1 | 8 | 11 | 56 | 12 | ||
96076 | 4160 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3739 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2003 12:00:00 AM | 3 | 4X4 | 6005605.4759646 | 2100485.3064168 | 37.7478497208127 | -122.423377031661 | (37.7478497208127, -122.423377031661) | 2 | 4 | 5 | 28859 | 22 | ||
96170 | 86320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988402.93355 | 2103727.210237 | 37.7557652078647 | -122.483099472181 | (37.7557652078647, -122.483099472181) | 1 | 8 | 3 | 56 | 35 | ||
96306 | 92531 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1298X Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 6011695.14318 | 2102366.06354 | 37.7533556870153 | -122.402451357562 | (37.7533556870153, -122.402451357562) | 10 | 3 | 8 | 28856 | 29 | ||||
96329 | 27095 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 711 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6006067.91108 | 2093593.97148 | 37.7289537443201 | -122.421288656069 | (37.7289537443201, -122.421288656069) | 9 | 7 | 6 | 28861 | 5 | |||
96517 | 2552 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 59 Burnside Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 25 | 3X3 | 6001211.45267 | 2095788.41504 | 37.7347041848314 | -122.438234897018 | (37.7347041848314, -122.438234897018) | 2 | 7 | 5 | 63 | 7 | ||
96983 | 91881 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 902 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992992.499251 | 2106644.894373 | 37.7640424113715 | -122.467439575398 | (37.7640424113715, -122.467439575398) | 11 | 8 | 11 | 56 | 12 | ||
97055 | 91987 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1327 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5993305.260305 | 2106445.773422 | 37.7635137289504 | -122.466343363346 | (37.7635137289504, -122.466343363346) | 1 | 8 | 11 | 56 | 12 | ||
97434 | 23488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | ||
98979 | 91931 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | 1 | 8 | 11 | 56 | 12 | ||
99524 | 4147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3555X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | ||
100038 | 106991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2014 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427 | -122.429819799587 | (37.785503891427, -122.429819799587) | 13 | 9 | 11 | 29490 | 13 | ||||
100783 | 21655 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1700 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004345.5648 | 2114673.53748 | 37.7867359926545 | -122.428745037681 | (37.7867359926545, -122.428745037681) | 13 | 9 | 11 | 29490 | 27 | |||
101591 | 89679 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2531 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990763.22917 | 2111957.72376 | 37.7785010440115 | -122.475537837476 | (37.7785010440115, -122.475537837476) | 11 | 6 | 2 | 54 | 26 | ||
101809 | 4069 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3120 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008908.10494 | 2100619.1862301 | 37.7484031705039 | -122.411966114964 | (37.7484031705039, -122.411966114964) | 2 | 4 | 7 | 28859 | 19 | |||
102098 | 91945 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 843 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993185.075419 | 2106611.467471 | 37.7639617458449 | -122.466771086585 | (37.7639617458449, -122.466771086585) | 1 | 8 | 11 | 56 | 12 | ||
103046 | 4032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
104059 | 6398 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | 10 | 3 | 8 | 58 | 1 | ||
104168 | 106992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427 | -122.429819799587 | (37.785503891427, -122.429819799587) | 13 | 9 | 11 | 29490 | 13 | ||||
105005 | 1353 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 284 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999905.46078 | 2099295.02318 | 37.7442581344216 | -122.443001884824 | (37.7442581344216, -122.443001884824) | 2 | 7 | 5 | 63 | 22 | |||
105625 | 91977 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1310 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993341.653751 | 2106551.295076 | 37.7638055635412 | -122.466225160061 | (37.7638055635412, -122.466225160061) | 1 | 8 | 11 | 56 | 12 | ||
107022 | 91929 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070 | 2106573 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | 1 | 8 | 11 | 56 | 12 | ||
107224 | 86109 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2548 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988950.841471 | 2097988.149582 | 37.7400391325334 | -122.480784510326 | (37.7400391325334, -122.480784510326) | 1 | 8 | 3 | 29491 | 35 | ||
107262 | 16450 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
107395 | 91980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1256 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993328.468873 | 2106934.546237 | 37.7648571097371 | -122.466298616883 | (37.7648571097371, -122.466298616883) | 11 | 8 | 11 | 56 | 12 | ||
108764 | 103040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
109043 | 103832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
109921 | 4295 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4342 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6001671.89746 | 2100317.83526 | 37.7471670905043 | -122.436967147015 | (37.7471670905043, -122.436967147015) | 2 | 4 | 5 | 63 | 22 | ||
110076 | 91901 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1500 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991109.054689 | 2106580.378462 | 37.7637563526576 | -122.473949083869 | (37.7637563526576, -122.473949083869) | 11 | 8 | 11 | 56 | 12 | ||
110085 | 86443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | 1 | 8 | 3 | 29491 | 35 | |
110462 | 28352 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3170 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008602.0157948 | 2100617.8635816 | 37.7483823610073 | -122.413024474721 | (37.7483823610073, -122.413024474721) | 2 | 4 | 7 | 28859 | 19 | ||
110583 | 86387 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1515 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988049.80199 | 2104982.670278 | 37.7591918054497 | -122.4844127767 | (37.7591918054497, -122.4844127767) | 1 | 8 | 3 | 56 | 35 | ||
113233 | 103761 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.57502 | 2115508.13748 | 37.7891597571573 | -122.420708413481 | (37.7891597571573, -122.420708413481) | 13 | 9 | 10 | 28858 | 21 | ||
114426 | 91905 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1550 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5990960.285269 | 2106575.282542 | 37.7637337423119 | -122.47446325445 | (37.7637337423119, -122.47446325445) | 11 | 8 | 11 | 56 | 12 | ||
115124 | 90437 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 34 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/14/2014 12:00:00 AM | 3 | 3x3 | 6006497.945377 | 2109373.750238 | 37.7723056459237 | -122.420921880831 | (37.7723056459237, -122.420921880831) | 8 | 2 | 9 | 28853 | 19 | ||
115591 | 104252 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
116541 | 91978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1294 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993337.095885 | 2106683.780998 | 37.7641690721016 | -122.466250553052 | (37.7641690721016, -122.466250553052) | 11 | 8 | 11 | 56 | 12 | ||
116801 | 94562 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 251X OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005545 | 2110135 | 37.774342092867 | -122.424272360307 | (37.774342092867, -122.424272360307) | 7 | 9 | 11 | 28852 | 10 | |||
117032 | 89678 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2543 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990738.94558 | 2111956.39246 | 37.7784959808887 | -122.475621745513 | (37.7784959808887, -122.475621745513) | 11 | 6 | 2 | 54 | 26 | ||
117130 | 91922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1431 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991341.486759 | 2106548.316844 | 37.7636817804625 | -122.473142842328 | (37.7636817804625, -122.473142842328) | 1 | 8 | 11 | 56 | 12 | ||
117389 | 214549 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 820 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2016 06:37:00 AM | 1 | Width 3ft | 5993190.74703 | 2106665.16617 | 37.7641095156677 | -122.466755374078 | (37.7641095156677, -122.466755374078) | 11 | 8 | 11 | 56 | 12 | ||
118376 | 26900 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 284 Amber Dr | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/1999 12:00:00 AM | 30 | 3X3 | 5999908.8159045 | 2099289.8400101 | 37.7442440939699 | -122.44298991141 | (37.7442440939699, -122.44298991141) | 2 | 7 | 5 | 63 | 22 | ||
118489 | 91946 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 839 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993196.982547 | 2106611.875341 | 37.7639635529319 | -122.466729933371 | (37.7639635529319, -122.466729933371) | 1 | 8 | 11 | 56 | 12 | ||
118975 | 85940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1554 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988098.748614 | 2104723.302763 | 37.7584825026991 | -122.484224476356 | (37.7584825026991, -122.484224476356) | 1 | 8 | 3 | 56 | 35 | ||
119262 | 86018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5987476.600405 | 2104728.077894 | 37.7584593699036 | -122.486376466049 | (37.7584593699036, -122.486376466049) | 1 | 8 | 3 | 56 | 35 | ||
119335 | 103764 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
119865 | 86078 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2253 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987600.724922 | 2099957.105994 | 37.7453667992034 | -122.485597061296 | (37.7453667992034, -122.485597061296) | 1 | 8 | 3 | 29491 | 35 | ||
120351 | 16451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1395 Newcomb Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2009 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
121331 | 91871 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 602 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 3 | 3x3 | 5993921.546454 | 2106676.718119 | 37.7641833831457 | -122.464228609956 | (37.7641833831457, -122.464228609956) | 11 | 5 | 11 | 56 | 12 | ||
122072 | 103833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
122433 | 4144 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3615-3623X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | ||
122741 | 12834 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 16 | 5 | 5988481.05496 | 2114714.7558 | 37.7859385147967 | -122.483634834967 | (37.7859385147967, -122.483634834967) | 11 | 6 | 1 | 55 | 33 | ||
122792 | 86214 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2491 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 04:31:00 PM | 3 | 3x3 | 5988896.775501 | 2098391.645558 | 37.7411438845393 | -122.481000981974 | (37.7411438845393, -122.481000981974) | 1 | 8 | 3 | 29491 | 35 | ||
122984 | 91992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1385 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5993318.248331 | 2106068.242865 | 37.7624778784584 | -122.466271003812 | (37.7624778784584, -122.466271003812) | 1 | 8 | 11 | 56 | 12 | ||
123507 | 103789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
123683 | 28243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | 10 | 7 | 8 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );